date critera for queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pilgrim - 15 Mar 2007 15:03 GMT

Hi, I am trying to create a Day's delivery sheet seem to have got most right
but am having trouble with the Queries and reports. I want to have either a
query or report that gives me that days deliveries. I have tried >=date in
the critera in Queries
to no succsess can't seem to find where it would go inreport.
any help gratfully accepted

Reply to this Message

Joan Wild - 15 Mar 2007 18:58 GMT

I assume that you have a table with deliveries in it and that one of the
fields is a date field. Create a query that includes the fields you want
and put a criteria under the 'date' field (don't call it date by the way) of

>=Date

You can then create a report based on this query.

If the query isn't working, post the reason why - it's not returning the
data you expect? - you're getting an error?

Signature

Joan Wild
Microsoft Access MVP

> Hi, I am trying to create a Day's delivery sheet seem to have got most
> right
[quoted text clipped - 4 lines]
> to no succsess can't seem to find where it would go inreport.
> any help gratfully accepted

Reply to this Message