How To Query Past Due Dates In Access 2007
example of the fields:
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Is there a way I can make the results be zero if the date past due is null?
Expr1: Format$(([MaxOfDateDone] [FreqDays]),"m y")
MaxofDateDone is a query that only looks at the last calibration done. Frequency Days is the number of days that a piece of equipment goes before it needs another calibration.
I'm having a problem with the following IIF function as query criteria. I'm referencing an option group on a form to determine what date of records to return. There are 4 options, Past Due, Past Due plus 30 days into the future, Past Due plust 60 days into the future, and All Dates. The criteria is as follows:
IIf([Forms]![Punch List Report Filter]![Past_Due]=1,"<Date()",IIf([Forms]![Punch List Report Filter]![Past_Due_Plus_30]=1,"<=Date()+30",IIf([Forms]![Punch List Report Filter]![Past_Due_Plus_60]=1,"<=Date()+60","*")))
Each time I run the query I get the error message "This expression is typed incorrectly, or it is too complex to be evaluated
One field has dates in it.
When these days are past due I need to know so I can check on the data.
I tried to make another field in my query to calculate this [FIELDNAMEHERE] > Date().
Do I need to create another field that has the current date in it and then make another field to say one is greater than the other or less than the the other or something? I really just need to know when the date entered into this field has passed so I can escalate on the issue
I also need the total of the balances for each period.
I am doing this with 4 queries right now. I would like to do it with one. How would I do that?
table 2 has a column with due dates
a request date must be before the due date
im writing a query for the two tables, but how do I just check the month?
ex: if request date's month = 01/11/2012 in table 1, I want it to scroll through all the dates in table 2 where it finds a due date also in january. (there will not be multiple due dates in the same month)
can someone help with putting this in the Design View of the query screen
What I want to do, is have it set up so that whenever the report is due, the dates will be automatically entered, and updated if the due date changes.
I know that in Access 2003, you could use the SetValue in a Macro, but I don't believe (but haven't seen anything that works the same) that option exists in 2007, and I believe that creating the code in VBA would probably be "easier."
If there's another topic dealing with this, I must've not been searching using the appropriate keywords, and for that I apologize.
Again, I'm using Access 2007.
Clients have a fiscal year end, for example 12/31 (could be 6/30, 4/30, etc.)
During that year they have 4 quarterly reports that are due 45 days after quarter end (with the exception of one client which is due 40 days after quarter end). I can set up a field to indicate that if necessary.
How can I design a table/query/report that will track when something is due for each client that hasn't been completed yet.
Do I need to manually create a record for each quarter's due date for each client or can I calculate this somehow?
Essentially I need a record for each due date. Currently am filling it in when it is done and manually looking to see when the next one is due. Can I have it do some sort of automatic creation of record for next due date when one is completed