Crosstab columns week ending date

[robsant]

Hi

I have created a crosstable that counts using week number columns.

However I really want to count everything within a week, but with a week ending on a sunday.

ideally showing column headings with just the sunday date, but a count of all orders within that week.

can anyone help please?

Thanks,

Rob

 

[plog]

Can you demonstrate what you want with data?

Provide 2 sets of data:

A. Starting sample data from your table. Include table and field names and enough data to cover all cases.

B. Expected results based on data in A. Using the initial data (A), show what you expect this query to return.