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
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