Question Date Problems

[MartL]

I wasnt sure if I am posting this in the right forum and I have tried using the search function but cant seem to find anything that helps a lot.

I have a DB of customers that we have fitted carpets for and we do follow up calls after a week or so, I can use the fitting date to find out what date the follow up call is due but I also want to use either a Report or Datasheet to view which calls are due. At the moment I can obviously get it to bring up all the jobs and I can see all the dates to see when it is due but Im wanting to make it so that only the calls that are due are actually visable. I would also like to do the same thing for Statements that go out after 30 days but I really dont know how about setting a filter or writing a query to do this.

I have a very basic knowledge of how to use Access and any help would be appreciated.

 

[Galaxiom]

The query designer criteria on InstallDate would be something like:

< Date() - 7

 

[MartL]

The query designer criteria on InstallDate would be something like:

< Date() - 7

Sorry like I say very basic user so Im not exactly sure what you are saying. Is that a forumla I would have to put in somewhere?

At the moment I use [Fitting Date]+7 to calculate a field called Follow Up Call. I have a report that shows all the orders until i click that a follow up call has been made and then any i do that to disappear. Like for instance I put one job on that we are fitting tomorrow and it flags that a follow up call is due on 28/9/12. The thing im trying to do is stop ones like that appearing until the call is actually due. So on the 28/9/12 that job would appear on the report.

Thanks for the help.

 

[Galaxiom]

Create a query in the design view. That formula goes in the Criteria line under the field column for the FittingDate. The query will only show the records that match that condition.

You can then make a report or form based on the query.

 

[MartL]

Ah right thank you. So basically the code is saying any date that is more than x amount of days which in this instance is 7 days. So any date over 7 days old will show and I guess I can use the same code for the statements.

I just couldnt get my head around how it could be coded. Thank you very much, I will give it a whirl.