I need a query that gives me
.........date.....date.....date
Name
name
name
name
This is like a crosstab query but I want a start time to show in the cross section of the table like this
............date.........date.........date
Name...7:00 AM.....8:30 AM....7:00 AM
name...8:00 AM.....8:00 AM....7:00 AM
(the periods are just place holders to make it look like a spreadsheet)
imaging this in rows and column like a spreadsheet
How can I make my query show the information that is in a field instead of a calculation.
Thanks,
Tina
.........date.....date.....date
Name
name
name
name
This is like a crosstab query but I want a start time to show in the cross section of the table like this
............date.........date.........date
Name...7:00 AM.....8:30 AM....7:00 AM
name...8:00 AM.....8:00 AM....7:00 AM
(the periods are just place holders to make it look like a spreadsheet)
imaging this in rows and column like a spreadsheet
How can I make my query show the information that is in a field instead of a calculation.
Thanks,
Tina