Is this possible???

[VeryNew]

I have a table that contains dates and Locations as well as detail regarding events.(all one table) I need to create a report that shows me Location and Date at the top of the page and then underneath every event that happened at that location on that date. I keep getting it shown as different date/location combos even when they are the same it treats it as though they are different.

Any suggestions?

Thanks for your time.

 

[JeremyNYC]

Read about data normalization. Your table should be broken out into two (or more) tables, and this will make things much easier to deal with.

On the other hand, you should be able to use the Sorting and Grouping feature in the report design to do what you need.

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.

 

[VeryNew]

Jeremy,
Thank you for your response. I know the table is not well designed and it could be done better. If i HAVE to leave it as is for the time being is there any way to solve the issue otherwise?
Thanks