F
Fred's
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
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