Microsoft Access Report

[Amy2710]

I have a main table and a sub-table/form - I have created a query to include 1 field from the main table and 2 fields from sub-table/form. These being Customer Name, date and notes. How can I place the date field as thus in a report format:

Customer (date)Wk16 (date)Wk17 (date)Wk18

(notes) (notes) (notes)

In other words how can I align the date field horizontilly and align the the notes that apply to that date underneath the appropriate date.

The report I have at present list as follows:

Company (date)Wk16 (notes)
Company (date)Wk17 (notes)
Company (date)Wk18 (notes)

Which doesn't look good at all!

Hope you can help?

 

[SuicidED]

Hi see if this helps
TRANSFORM First(Table1.Notes) AS [The Value]
SELECT Table1.Customer
FROM Table1
GROUP BY Table1.Customer
PIVOT Table1.WeekNumber;