Hi there,
I am putting together a simple cashflow database that uses information from a purchasing system, a grant management system and MYOB to show up to the date cashflow analysis.
I have a date field and an option group that lets the user select how they would like to search/see particular records.
The user enters a date and then selects from the options: by week, by month, by financial year, by financial year qtr and all records. When a selection is made I would like an unbound text box to show the search criteria.
We want to limit the reports to be whole weeks - Sun thru Sat - or whole months etc so I don't really want a free hand start date/end date parameter query.
eg.
If user enters 1/3/06 and selects:
1) by week. Then text box says: Week 10 - 27/2/06 to 5/3/06
2) by month. Then text box says: Mar-06
3) by financial year. Then text box says: FY2006
4) by financail year qtr: Then text box says: Q3-2006
I have set up an excel spreadsheet that shows all dates for 3 years and has a month column, a week column and a financial year column each worked out using a fromating date formula from the original stand alone date. Is there a way of automating this in access?
Thanks in advance for any help.
FNQChick
I am putting together a simple cashflow database that uses information from a purchasing system, a grant management system and MYOB to show up to the date cashflow analysis.
I have a date field and an option group that lets the user select how they would like to search/see particular records.
The user enters a date and then selects from the options: by week, by month, by financial year, by financial year qtr and all records. When a selection is made I would like an unbound text box to show the search criteria.
We want to limit the reports to be whole weeks - Sun thru Sat - or whole months etc so I don't really want a free hand start date/end date parameter query.
eg.
If user enters 1/3/06 and selects:
1) by week. Then text box says: Week 10 - 27/2/06 to 5/3/06
2) by month. Then text box says: Mar-06
3) by financial year. Then text box says: FY2006
4) by financail year qtr: Then text box says: Q3-2006
I have set up an excel spreadsheet that shows all dates for 3 years and has a month column, a week column and a financial year column each worked out using a fromating date formula from the original stand alone date. Is there a way of automating this in access?
Thanks in advance for any help.
FNQChick
