struggling with query criteria

A

Ashley

Hi,

I struggling how to specific criteria in the query from a
table that grouped by month of shipdate.
I would like query to count only if ship month is equal to
due month.
For Example,
If an item shipped on 9/8/04 and it due on 10/5/04, then
don't count.
If an item shipped on 9/1/04 and it due on 9/5/04, then
count it.

Thanks
Ashley
 
F

fredg

Hi,

I struggling how to specific criteria in the query from a
table that grouped by month of shipdate.
I would like query to count only if ship month is equal to
due month.
For Example,
If an item shipped on 9/8/04 and it due on 10/5/04, then
don't count.
If an item shipped on 9/1/04 and it due on 9/5/04, then
count it.

Thanks
Ashley
Click to expand...

Where Format([ShipMonth],"mm/yyyy") = Format([DueMonth],"mm/yyyy")
 
Top