Report date field and sort it by year/Month/Week (Oldest to Newest)

[TBC]

Hello,

I'm trying to create a report based on a query

I'm looking for a formula that will take my Report date field and sort it by year (Oldest to Newest)
I would also like to put this date in a Colum header for each row year (Oldest to Newest)

I would like to continue breaking down the query/Report to take Report date field and sort it by month (Oldest to Newest)
again I would also like to put this date in a Colum header for each row year (Oldest to Newest)

Is there a formula that will do this in the query and if need be the report


Please see the attached report for an example

I'm also looking for a way I can take this report sort (Oldest to Newest) and on a form allow me to enter an amount (example) 500,000 from older Report Amount and export all those account that add up to 500,000

Thank – TCB

 

[plog]

You've bitten off more than we can chew. Your description makes it sound like you have one report you need help with, but you posted like 6 different ones (some which contain sub-reports). For us to help, you need to focus on one report and then list your issues with it.

Where would you like to start? Repost that report and specific issues you are having with it.

 

[TBC]

Can we start by looking at this one

I'm looking for a formula that will take my Report date field and sort it by year (Oldest to Newest)
I would also like to put this date in a Colum header for each row year (Oldest to Newest)

I would like to continue breaking down the query/Report to take Report date field and sort it by month (Oldest to Newest)
again I would also like to put this date in a Colum header for each row year (Oldest to Newest)

 

[GinaWhipp]

<Have not looked a reports>

Sounds like you need a Crosstab query, so... you first need to create those fields in your query then create a Crosstab.

 

[plog]

Can we start by looking at this one

Which one is 'this one'?

Can you please upload the report you are trying to achieve. A few of the ones you initially posted aren't easily achievable in Access but are in Excel with a Pivot Table.

 

[MarlaC]

In the query which is the recordsource for your report, create calculated fields for each portion of the date that you need to sort by using the DatePart function. Then use the Group and Sort part of the report designer to group and sort on those fields.