Results 1 to 7 of 7

Thread: [RESOLVED] Simple Criteria Expression?

Threaded View

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Mar 2006
    Posts
    367

    Resolved [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
  •  



Click Here to Expand Forum to Full Width