Report in Access (Access 2000)

Topic

New Reply

Hi Everyone,

I am trying to create a query based on criteria of dates. I have 2 tables one with event name id and event names field and the other table with the event name id and event dates. It is a one to many relationship.
One event to many dates. I am trying to create a query that has event names held in January and then event name held in February and so. I would like the name of event and then date displayed.
I am enter criteria of between 010102 AND 310102 etc and running the query and nothing is displayed.
I have tried other ways with no luck.
Any ideas of what to look at?

Thanks Kindly,

Kerrie

Reply | Quote

Replies

Are you enclosing date criteria as such:

#01/01/2002#

in the query?

also look at format property for working/returning dates

Reply | Quote

Hello,

Thanks for the date format I tried it and it worked perfectly. I am also to do the following. In the query the first column has the event name the second column has January’s event, then in the 3 colomn I want to put February’s event dates. When I setup the query to display on those event’s held in January it works.
However when I then add another column and setup the criteria to display only February – So I have event name, then dates for Jan, then dates for Feb, it displays nothing. It is as if it is comparing both columns????
Any ideas….
Thanks Kindly,

Kerrie

Reply | Quote

Store all dates in the one column. There is no reason for a third February date column if I understand you correctly and that is what you are doing.

Reply | Quote

Hello again,

The reason why I would like the 3rd column is because I want to base a report on this query.
I would like the report to look lie the following:

Event name January February March
Event 1 23/01/2002 4/02/2002
24/01/2002
Event 2 1/02/2002 5/03/2001
Event 3 30/01/2001 7/03/2001
and so on

So if the query listed the different events and their dates in different columns I would base the report on
that. At the moment it only displays January’s event and dates.
And displays them in a report above.

Kerrie

Reply | Quote

OK, base report on table or a query.

In details section of report just place controls all on same level.

event date1 date2

This will display all info in table.

Key is placing controls in report at same horizontal level.

Reply | Quote

Hello again,

I have worked out that whenever I try criteria using between or >= AND <=, that I get no data.
I I use # at the end and start of the dates it give me an error "…expression is incorrect…"

Kerrie

Reply | Quote

Post your criteria. It should be like:

Between #1/1/02# and #1/31/02#

Reply | Quote