Outstanding Visits...(Help With Report)

Jul 17, 2006

Oh my gosh, how frustrating! I'M TRYING (so desperatly) to create a report that will show me how many outstanding inspection visits to a business. I don't know if i'm going in the right direction but, i've created the report with a date range form. the main purpose for this report is to show me how many visits I'm behind by typing in a date range. For example i want to know how many outstanding i have between 1/1/05 to 1/1/06. Visits are done annually. so i need for it to pull up the ones that weren't done. it's complexed for me to elaborate on it so i've attached it..

View Replies


ADVERTISEMENT

Huge Report With Visits Per Customer - Get Information Of Last Visit

Dec 2, 2013

We have a huge report in our company that includes all our customers, all the visits done by our sales reps, all the products they have and if a product was out of stock in the visit or not.

I want to create a querry that exports a table with 3 columns:

1-->customer
2-->date of last visit
3-->average of out of stock products on the LAST visit

I tried to make a pivot table, managed to grab the last visit (setting the date to maximum) but the average of out of stock products were aggregated totally and not for the last day.

How to handle this in MS access 2010?

View 2 Replies View Related

Queries :: Huge Report With Visits Per Customer - Grab Information Of Last Visit?

Dec 2, 2013

we have a huge report in our company that includes all our customers, all the visits done by our sales reps, all the products they have and if a product was out of stock in the visit or not.

I want to create a querry that exports a table with 3 columns:

1-->customer
2-->date of last visit
3-->average of out of stock products on the LAST visit

I tried to make a pivot table, managed to grab the last visit (setting the date to maximum) but the average of out of stock products were aggregated totally and not for the last day.

how to handle this in MS access 2010?

View 9 Replies View Related

Setting A Field To Outstanding

Oct 11, 2006

Im not sure if this is the right area to post this but what i wanted to know is how i would set the field "status" to OutStanding when a record is added into the table.

View 2 Replies View Related

From Query To Graph - Running Sum Of Tasks Outstanding

May 10, 2006

Hi,

I am still confuse after reading threads on producing running sum on queries. help!

This query is to produce a time line graph of Progress Tasks with 3 main categories - New, Completed and Outstanding. So I got months on the x-axis and count on the Y-axis.

sample data.
say we look back for jobs in the month in feburary
Date Added; Date Completed ; category
11/1 ; NIL ; Outstanding
11/1 ; 1/3 ; Outstanding
11/1 ; 14/2 ; Completed
1/2 ; NIL ; Outstanding
1/2 ; 1/3 ; New and Outstanding
1/2 ; 14/2 ; New and Completed

so the total count of the categories for Feburary
New = 2 ,Completed= 2, Outstanding=4

can anyone help?

thanks
galantis

View 1 Replies View Related

General :: Query Formula - Allocated Qty Not To Be Summed Back Onto Qty Outstanding

Nov 20, 2014

Below is a formula that I have in my query. The problem I now have come up with is sometimes I will not want the allocated qty to be summed back onto the qty outstanding.

I have more fields in my form ( allocation)of which one is called " consumable" what I need the formula below to do is the consumable is not empty then don't add the " qty allocated" to the "qty outstanding"

Code:
qty required: IIf(DLookUp("[material]","Allocation","material= '" & Stocklist.material & "'") Is Null,[qty outstanding],[qty outstanding ]+DSum("[qty allocated]","Allocation","material= '" & Stocklist.material & "'"))

View 2 Replies View Related

Calculate Visits Per Month

Jun 28, 2005

Hi All.
I need to calculate how many visits per month. What formula in a query I need to use to calculate the same value of DATE field.
Thanks.

View 5 Replies View Related

Recording Visits To A Form

May 31, 2005

Is there a popular way to show when records are updated, with something like a text box with Now(), please, Gurus?

It needs to be automatically enacted. (A box that they complete themselves gets quickly forgotten.)

Then if the Client refers to records changed on such and such a date, I can find them instantly.

View 10 Replies View Related

Calculate Visits Per Month

Jun 28, 2005

Hi All.
I need to calculate how many visits per month. What formula in a query I need to use to calculate the same value of DATE field.
Thanks.

View 1 Replies View Related

Tables :: Database For Recording Visits - File Number For Each Day

Dec 17, 2014

l have a database for recording patients visits in a hospital,in addition for "serial" field I want to make "fileNumber" field which represents a continous serial number changes everyday but of course all visits in the same day have the same filenumber as in follows..

Ser-----Date----------FileNum
===========================
1-------17.12.2014------1
2-------17.12.2014------1
3-------17.12.2014------1

1-------18.12.2014------2
2-------18.12.2014------2
3-------18.12.2014------2

I cannot depend on date (I think) in the desired code because I want to skip weekend and holidays so FileNum continues after weekend (Friday) from the last number as follows..

DayOfWork----FileNum
===================
Sat---------------1
Sun--------------2
Mon--------------3
Tue--------------4
Wed--------------5
Thr---------------6
Fri---------------off
Sat---------------7
Sun---------------8

View 14 Replies View Related

Does MS Access Report Support Hide/Show Fields At The Report View Time?

Aug 19, 2007

Does the MS Access Report support Hide/Show specific fields according to parameters or even by click?

View 3 Replies View Related

General :: How To Make A Report Using Crystal Report Direct From MS Access Form

Jun 3, 2014

I'v looking for since a couple months a go to make a report direct from access form using crystal report but i havent found it yet. I'v tried this code and its giving me errors. " run time error 1004 method range of object _global failed "

how to make a report using crystal report direct from ms access as front end application ? is it possible to use crystal report ?btw i use database sql server 2008 and MS Access 2007 as my frontend application.here's the code that i'v found and gives me an error

Dim CR As New CRAXDRT.Application
Dim rep As CRAXDRT.Report
Set rep = CR.OpenReport(Range(" ??? ")) * i getting error in this line, what should i do to fill it ??
rep.ParameterFields(1).AddCurrentValue "Boston"
rep.ParameterFields(2).AddCurrentValue "Cars"
rep.Database.Tables(1).SetLogOnInfo "tool", "db_tsel"
rep.ReadRecords
rep.PrintOut promptUser:=False, numberOfCopy:=1 ' promptUser:=True doesn't work

View 2 Replies View Related

Forms :: Open Report Button To Select Data From 7 List Boxes And Present In A Report?

Aug 13, 2015

I have a form with 7 List boxes linked to 7 Query's which in turn are linked to a table. Each list box if for a particular trade.

I am trying to select a person or persons from each List box and then have them sent to a report. I have Code to do one list box, but do not know how to link all boxes with code to a 'Open report' button.

The code I am using is as follows:-

Private Sub cmdOpenReport_Click()
On Error GoTo Err_cmdOpenReport_Click
Dim strWhere As String
Dim ctl As Control
Dim varItem As Variant
'make sure a selection has been made

[code]....

View 9 Replies View Related

Reports :: Filtering Report To Only Show Current Month Report?

Nov 16, 2014

The aim of what I am doing is to create a monthly statement to give to our intermediaries that shows the commission they will receive each month for the deals they have referred. I have managed to create this report, HOWEVER I can't figure out how to filter out which month I need, so I a report for Jan, Feb Mar etc... The idea is that at the end of each month I need to run the report so only the latest month shows...

View 3 Replies View Related

Modules & VBA :: Programmatically Alter Detail Of Report Then Use That Report As Subreport

Jun 26, 2013

I have a report which programmatically sets the value of some labels based on its own internal logic for each line of the detail section of a report. This all works fine and dandy, using the Detail_format event, and accessing detail.controls.item(x).caption.

HOWEVER, when I then embed the report as a subreport (which I need to do), I goes wrong. Here, I get the values of the last row of the detail repeated in every previous one. I'm suspecting because the parent report has its own 'detail' (I've tried giving the subreport its own distinct detail name).

View 1 Replies View Related

Reports :: Hide Report Footer Based On Report Data?

Dec 21, 2014

How do I hide the report footer based on the report's data ?

I'm trying to hide if number of users = 1

The report's data is a query built inside the report's RecordSource, not a self standing query.

View 10 Replies View Related

Reports :: Unfiltered Report Footer Totals On Filtered Report?

Apr 10, 2014

I've done this once entirely by accident and can't seem to duplicate it...

I have a report. It has the following:

Report Header: Logo and title
Department Header
Supervisor Header
Group Header
Detail
Department Footer: Totals
Report Footer: Overall Totals for all departments

Here's my question.
I have combo boxes on my main form that filter this report. The combo boxes are referred to by the query that runs the report. How do I get proper unfiltered overall totals in my report footer?

View 4 Replies View Related

Reports :: Join Smaller Report On The Back Of Main Report?

Apr 18, 2013

I have a report that displays incidents, their details, consequences and a photo. Among the details is a severity rating high medium or low, I have been asked to make the report shorten the records which have been given a low severity (because it takes up as much space as the more important/severe ones).

The only method I can think of is to use the onformat event, to shrink and make invisible all the fields that I don't want to see if the severity field shows 'low'.

View 3 Replies View Related

Reports :: Select Records From Report To Populate Second Report?

May 24, 2015

We have a shift log that includes both personnel actions during any given day as well as operational actions. (We recently switched from a word document to an Access Database to allow multiple users to input events while another has the logbook open already (which you couldn't do with Word))

At the beginning of each day, my manager reviews the previous days log and forwards up pertinent data (some personnel, some operational) to our higher authorities. Is there a way to allow him to select which records he'd like to include on that higher-authorities report straight from the local-level report?

I'm not a fan of allowing him a "Save As" feature because that kind of defeats the data integrity purpose of an events log where he could save as an RTF and then edit any of the log entries without any checks or balances.

View 2 Replies View Related

Reports :: Scrolling Down Report Changes Report Fields To Errors

Jun 26, 2013

I have an odd thing happening with my reports. There is a main report that gives class information (from query). There are two subreports (from queries also ) with scores (one for each type of test). There are some unbound controls on the main form that display a count of how many scores are recorded which are totals from the subreports. The controls all report the correct numbers however, when I scroll down to view each record, some of them change to #error, or #name, or similar for a moment. Sometimes they will stay in error form when I stop scrolling but change to correct if I scroll up just a bit. Is this because the controls won't calculate unless that report record has focus?

View 1 Replies View Related

Queries :: Utilization Report - Multiple Query Into One Report

Sep 2, 2014

I have a three-column query that tells me how many hours I have available per week for a given resource type (e.g. welders). I have a second three-column query that tells me how many hours of work I have planned per week for a given resource type.I'm hoping to produce a query (the source for a report) that will show resource types in rows and twelve months in 24 columns. the first column for each month will show how many hours I have available for all my resources, the second column for each month will show how many hours I have allocated.

How do I produce a query that will combine the other two queries, inserting zeroes where necessary considering that for any given week I might have allocated work to a resource that isn't available (because the inconsiderate buggers think they are entitled to holiday) or I might have a resource that has no work allocated (because I'm incompetent)?

View 8 Replies View Related

Reports :: Hide Report Label If Sub Report Count Is 0

Dec 18, 2013

Is there a way to hide a label on a report if the sub report count is 0?

View 2 Replies View Related

Sub Report - Data Stops Appearing In Sub Report After Page 2?

Dec 21, 2012

I have an asset data base to generate individual asset detail reports with a sub report on the same page listing similar assets from a separate query. I have set the master and child fields, one to many. This works perfectly for the first two assets (pages), however the sub report stops showing data on the third asset (page).

View 13 Replies View Related

Main Report Portrait Sub Report Landscape

Dec 20, 2004

Hi,

Can you tell me if it is possible to create a main report with a Portrait view and then add a sub report to the main report and print this out in landscape mode. If you can please can you advise on the best way to do this. Thanks PWF

View 1 Replies View Related

Reports :: Pulling Data Into A Report From Another Report

Mar 20, 2015

So I have a text box in a report that I want to pull in data from a field in another report, so the 'control' for my text box looks something like this...

=[Reports]![rptSalesReceiptSub]![Text141] (i.e Text141 is the data I want to pull into my report)

...the path is completely correct but when I run my report I get.#Name? If I run the report that has the data I want, it's fine (in other words Text141 has valid data in it)

View 4 Replies View Related

Reports :: Possible To Send Report As XLS And Keep Format Exactly As Report Looks

Jul 11, 2013

I am wondering if it is possible to send a report as xls file and keep the format exactly as the report looks.When I try to send it now, it automatically changes back to the column names from the table, which I in the report have changed and want to keep in my excel output!

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved