Access Switchboard and retrieving data

  • Thread starter Thread starter Missy
  • Start date Start date
M

Missy

I have a database set up with all the fields, forms, reports, queries, etc
that I need. I have it all connected to a switchboard because there are four
people who will be using this. The problem I'm running into now is that each
quarter there will be new data (fields will be the same) but for each query,
report and form will need to change to the new quarter, but be able to
retrieve data from the old quarter at times. Is there an easy way to do this
other than creating a new set of queries, forms and reports each quarter?
 
Nothing to do with switchboard.
In your queries break the date down using date functions to year and quarter
like this --- Year([YourField]) OR Format([YourField], "yyyy") and
Format([YourField], "q")
Use the same in the forms and reports.

You can have query/report to default to previous quarter reporting by using
 
Back
Top