Compare and count dates in access

[Michael Curtis]

This is kicking my @#$%. I have been asked to do a performance report
for our vendors. I need to compare and count dates.

1. Is called [del date on po] which is in a table named JOB DATES

2. Is called [ship date] which is in a table called SHIP LOGS

I need >,<, and = to the ship date.

PLEASE HELP

Ive tried queries forms and reports to do this but none seem to work.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Larry Linson]

Create a Query to retrieve the fields of interest, using appropriate
criteria to select the records you want, then in Design View of the Query,
on the menu, click View | Totals. One of the options will be Count.

If I have misunderstood your needs, please clarify and perhaps someone can
be of assistance.

Larry Linson
Microsoft Access MVP
"Michael Curtis" <mi**@faubionassoc.com> wrote in message
news:42**********@127.0.0.1...

This is kicking my @#$%. I have been asked to do a performance report
for our vendors. I need to compare and count dates.

1. Is called [del date on po] which is in a table named JOB DATES

2. Is called [ship date] which is in a table called SHIP LOGS

I need >,<, and = to the ship date.

PLEASE HELP

Ive tried queries forms and reports to do this but none seem to work.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Michael Curtis]

The count expression only outputed a 1 if the field had some data in it.
I need it to count the total records meeting my criteria.

Tried:

Expr1: Count(([del date on po]<[ship date]))

And it gives the 1's if it is there but i need the sum.

Also,

How to i reference that on the report, tried to querry it but that does
not work for me.

Thank you...
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Douglas J. Steele]

Try

Expr1: Abs(Sum([del date on po]<[ship date]))
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Michael Curtis" <mi**@faubionassoc.com> wrote in message
news:42**********@127.0.0.1...

The count expression only outputed a 1 if the field had some data in it.
I need it to count the total records meeting my criteria.

Tried:

Expr1: Count(([del date on po]<[ship date]))

And it gives the 1's if it is there but i need the sum.

Also,

How to i reference that on the report, tried to querry it but that does
not work for me.

Thank you...
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!