date choice

[pastorkc]

Is there a way in access either by query or report to have the user select a date range before the query is run? For example the user wants to run a report for a specific fiscal year.

 

[Joe4]

You cannot place an ORDER BY clause in each part of the Union Query; it is only allowed at the very end on the entire collection of data.
When using ORDER BY, you can use field index instead of field name, which I finds seems to work better with Union queries.

Sort "ORDER BY 8" means "sort by the 8th field".

 

[pastorkc]

Oh that makes sense. I think I have just been looking at this to much and got overwhelmed. Thank you again.

 

[Joe4]

The learning curve on Access is very steep. If you jump into too quickly, you can easily program yourself into a corner.
My first database project in Access was an utter disaster, and after 3 months I had to scrap what I had and start over.

I HIGHLY recommend that in addition to learning the ins-and-outs of Access, make sure you have a good understanding of the aspects of Relational Databases, especially the Rules of Normalization.
If you do not set up your data tables according to the Rules of Normalization, you are going to eventually find that seemingly simple tasks become difficult and cumbersome and/or the database won't be very dynamic.

 

[pastorkc]

Understood. Thank you