Creating an audited report for help website

[sequenced]

I am trying to create a report for my access database (which is designed to help me keep a track of changes to pages for a help site).

Some pages in order to ensure they are up to date need to be regularly audited and others need audited less regularly. I have got fields in the table 'Audited' (Date/Time) and 'Audit Cycle' (Number).

The Audit Cycle is how often it needs to be audited in months so eg

Audited - 01/01/07
Audit Cycle - 12

Would mean it needs to be audited every twelve months, next on 01/01/08

I am not sure how I would go about what I want to achieve but as I plan to have into the 100's of pages for the site when it's all up and running i would like to be able to run a daily/weekly report that will tell me what will need modifying within the coming week.

I am relatively new to access (eg I've open it and tried to piece it together) and apologise in advance if I have approached this all wrong.

 

[DrSnuggles]

Look at DateDiff and DateAdd.

For instance, to how many months difference in 12 months time:
date() - is todays date.

datediff("m",date(),Dateadd("m",12,date()) )

 

[sequenced]

Thanks for your response

Where would I put this datediff information? would I have to write it out for each record when it's created? as not all records will need to be audited every 12 months

 

[DrSnuggles]

In a query, add your Audit table.
Display the two columns Audit and Audit Cycle in the design grid of the query.
Then, copy each of the below into two new seperate columns:

Days_Until_Next_Audit: DateDiff("d",Date(),DateAdd("m",[Audit Cycle],[Audit]))

Months_Until_Next_Audit: DateDiff("m",Date(),DateAdd("m",[Audit Cycle],[Audit]))

You can then filter on either days or months
Example In the Criteria for column Days_Until_Next_Audit type <=5. This will then display all the pages coming up for review/audit in the next 5 days.

Build up the query or use it in another to then build up the RecordSource Query for your Report.

Just some advice, I wouldn't use spaces in fieldnames. Use an underscore.
Plus normalize your tables, if you haven't already.