Search results

no I dont, the list of all days would be a list of all days that exist in the table, is there a way af automating that?

Ok I have that. I've tried linking the all minutes table to the original table by the times but I'm getting 'Type mismatch in expression' Is this what you had in mind?

Thank for the reply plog No I don't have every minute of every day as this is a query I'm going to need to run every day with new data, this data is from an external system which is why I have the date and time in seperate fields, also in this case teh date and time don't technically relate...

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