Structured data (1 Viewer)

Rupa

Registered User.
Local time
Today, 07:36
Joined
Nov 14, 2008
Messages
22
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

Super Moderator
Local time
Today, 07:36
Joined
Jul 10, 2007
Messages
5,906
Look at grouping within Reports. This should let you display the data for each location separately under a location heading.
 

Users who are viewing this thread

Top Bottom