Access report duplicating a record

[saepl]

Hello,

I am creating a group tour registration database for a non-profit organisation. The organisation has 5 different types of group tours they offer and one of the tours is a two day tour. I have created a report that summarizes all the tours grouped by day. The problem is that I need the two day tour to show up for both days. Any ideas how I can do this?

 

[genomon]

Sounds like you need to tweak your database to have a "start date" & "end date" fields; or, you need a unique identifier for a key if you want to have two "date" records for the two-day tour.

"Time flies like an arrow; fruit flies like a banana."

 

[saepl]

I have been thinking of having a start date and an end date. How would I set up my query to only show the end date ones where the start date is different?

 

[genomon]

I think better would be group on start date so you get two detail lines for the two-day tour, and display end date on the report when it = start date.

"Time flies like an arrow; fruit flies like a banana."

 

[saepl]

Where do I program it to only show if the end date != the start date? Is this done at the query or report level?

 

[genomon]

You could put it in the report's group header format or detail format events.

"Time flies like an arrow; fruit flies like a banana."