Dates Horizontally in Report

[Youngfighter]

Database81.accdb
15.zip

I need to show field values in relation to dates, but I want the dates to be shown horizontally in the report.

I tried the crosstab query but it is not working for me, as i need to report many unrelated rows.



I've attached brief explanation of what i want.

Thanks in advance for the help.

[June7]

These two tables can be combined into one.

tblSomething
Day
Quantity
Category (permit, meeting)

Or build a UNION query.

SELECT Day, Number_Of_Permits AS Quantity, "Permits" AS Category FROM Permits
UNION SELECT Day, Number_Of_Permits, "Meetings" FROM Meetings;

Now use the one table or the UNION query in a CROSSTAB query. Review http://allenbrowne.com/ser-67.html#Param

[Youngfighter]

Jun7, done - Thanks you very much