|
-
Dec 7th, 2006, 11:38 AM
#1
Thread Starter
Hyperactive Member
[RESOLVED] Simple Criteria Expression?
Using access 2000.
I created a query in design mode and have two tables linked by acct number. I have all the fields from both tables listed below in the field columns.
I added two addition caluclated fields.
Funding Date: DateAdd("yyyy",1,[FundDate]) 'this adds a year to the date
Date Diff: DateDiff("d",[ExpireDate],[Funding Date]) 'displays the difference in days between the two dates
On the criteria for Date Diff I put... >= 60 .... so it will display any record which has expired 60 or more days before the Funding Date.
However, when I try to run the query it asks me to enter the Parameter Value for Funding Date. Why? If I run the query without the criteria it shows them all no problem, but as soon as I use the criteria I get that message. Am I over looking something?
Last edited by lilmark; Dec 7th, 2006 at 12:10 PM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|