Query/Report date parameter

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Fred's - 29 May 2007 21:15 GMT

Hi folks,

I have a problem which, I hope someone can help me.

I have a table that have the following fields:
ID
Date
Supplier name
Merchandise type
T01
T02
T03

PS: T01,T02 and T03 are error type feild, which I can enter quantity
of units affected.

Now I need to have a report that show me the grand total of each error
types ("T01,T02 and T03),
the report will need to have a date paramater.

I've tried, but each type its only giving me the grand total of error
by date and not the grand total by error types, because I am adding
the following parameter in the query "Between [Start Date] And [End
Date]"

Can somebody help me.

Your help will be very appreciated.

Thanks - Fred's

Reply to this Message

NetworkTrade - 29 May 2007 22:41 GMT

If your query is returning all the proper line items...........then you
should be able to create a new report based on that query using the report
wizard - and one of the options during the wizard prompts is sum, avg,
etc.... you can select to sum T01, T02, T03....and the report will be made
to generate those totals you seek...

Signature

NTC

> Hi folks,
>
[quoted text clipped - 26 lines]
>
> Thanks - Fred's

Reply to this Message

Fred's - 30 May 2007 00:51 GMT

On May 29, 5:41 pm, NetworkTrade
<NetworkTr...@discussions.microsoft.com> wrote:

> If your query is returning all the proper line items...........then you
> should be able to create a new report based on that query using the report
[quoted text clipped - 37 lines]
>
> - Show quoted text -

Hi NTC,
the report I need must have also a date parameter, because when I run
the report, I need to choose a start date and an end date.

Thanks,
Fred's

Reply to this Message

NetworkTrade - 30 May 2007 17:28 GMT

Date bound reports are common - and there are a couple of ways to do it ;
kind of depends on the user interaction that you seek. Generally I like the
user to put the dates into a form's unbound text boxes......then I use those
dates in the query......and source the report on the query....

there is a more streamlined method using the opening arguments of the
report...but this 3 part approach is very straightforward for trouble
shooting....

For example...call the form DateForm with StartDateTxtBox and EndDateTxtBox

you call this info into the query design as a parameter field:

>=Forms!DateForm.StartDateTxtBox AND <=Forms!DateForm.EndDateTxtBox

run the query to make sure it returns all the lines/records correctly......

then make a report based on this query....

You can also carry these dates passively over to the Report so the report
tells you which date span it is for simply by adding a couple unbound text
boxes on the report and plugging in those same values from the form into them
using the same syntax.....

hth

Signature

NTC

> On May 29, 5:41 pm, NetworkTrade
> <NetworkTr...@discussions.microsoft.com> wrote:
[quoted text clipped - 46 lines]
> Thanks,
> Fred's

Reply to this Message