Compare and count dates in access

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!

re: Compare and count dates in access

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" <mike@faubionassoc.com> wrote in message
news:42279123$1_2@127.0.0.1...[color=blue]
>
>
> 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![/color]

re: Compare and count dates in access

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!

re: Compare and count dates in access

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" <mike@faubionassoc.com> wrote in message
news:4228c8c4$1_1@127.0.0.1...[color=blue]
> 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![/color]