Structured data

[Rupa]

Hello all,

I have a table with the following columns:

Location, Time, Alert Type
Value 1 08:00, Start time
Value 1 21:00, End Time
Value 2 09:00 Start time
Value 2 15:00 End Time
Value 2 08:00 Start Time
Value 2 21:00 End Time

I would like to organise it in such a way that you can see all the locations and all its start and end times without showing duplicate values of locations. I tried reports and crosstab queries but can't seem to get a structure.

Hope this makes sense. It would be great if someone could point me in the right direction.

Many thanks,

Rupa

 

[Rabbie]

Look at grouping within Reports. This should let you display the data for each location separately under a location heading.