Change Access report formula

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

brucehiner

Thread Starter
Joined
Aug 31, 2012
Messages
5
Hi I am very new at this and out of my element.
I have a standard monthly report that generates list to update client data every 6 months. The formula needs to be changed to fit our new needs. I do not know how to access the standard formula to replace it.

the old formula looks from current day out 30 days for needed for 6 month updates. What I would like is one that will generate a list for just the reports in that month as all due dates are now the first of the following month (no matter what the day is all 6 month updates are due from the month not the day anymore ie all June are due in Dec 1).:confused:
Bruce
 

OBP

Joined
Mar 8, 2005
Messages
19,895
Bruce, you will need both of the Queries in the attached database.
Assessment Reminders needs replacing and pre Assessment Reminders needs adding in both of your front databases.

This will give you a list of anything due this month, if you want it to give you anything due next month change the change the value in the Pre assessment from 182 back to 152 as it was in the original Assessment Reminders.
 

Attachments

brucehiner

Thread Starter
Joined
Aug 31, 2012
Messages
5
Thank you so much Need help with updates Need parameter values to get the querry to work asking for pre Assessment Reminders.fullname to ClosingDate
can send screen pic if needed
 

brucehiner

Thread Starter
Joined
Aug 31, 2012
Messages
5
Thanks again OBP. What do I need to open to access the value to change it from 152 to 182?
 

brucehiner

Thread Starter
Joined
Aug 31, 2012
Messages
5
Thanks again Found and can do. What about the parameter values ask for to get the updated Assessment Reminders running?
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top