Hi Experts,
I have a table containing fields for Date, Time, and amount.
I want to create a crosstab query with:
- Date as the column header
- Time as the row header
- Sum of Amount as Value
This is easy enough however, I want the query to show all minutes of the day in Time, regardless of whether any record has this minute of the day. I want these to display as null values.
What's the best way to go about this?
Thanks in advance!
I have a table containing fields for Date, Time, and amount.
I want to create a crosstab query with:
- Date as the column header
- Time as the row header
- Sum of Amount as Value
This is easy enough however, I want the query to show all minutes of the day in Time, regardless of whether any record has this minute of the day. I want these to display as null values.
What's the best way to go about this?
Thanks in advance!