How to get a particular field from a table as criteria in a query?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hkgary33 - 20 Jul 2006 14:26 GMT

Dear all,
In my database, I have a table named tblMemoPeriod, which only stores one
number field & one record named “MemoPeriod” to store the default period (in
days) of a memo. I’ve also built a form named frmChangePeriod so that the
user can change the default period of a memo, and then the “MemoPeriod” field
will be updated. Now I need to create a query that search out those files
with the memo field expired. For example, in file 1, its MemoDate field is
2006-06-18, and the MemoPeriod is set to be 30, and say today is 2006-07-20,
so suppose file 1 should be shown after the query.
But in the criteria field of the query, how can I get the value of MemoPeriod
field from a table and use it as a criterion?
Thanks!
Gary

Reply to this Message

Duane Hookom - 20 Jul 2006 14:56 GMT

If I understand correctly and tblMemoPeriod has only one record, you can add
it to your query and place the field in the criteria. I doubt this query
will be updateable.

If you need it to be updateable, don't add the table to your query and set
your criteria using something like:
DLookup("MemoPeriod", "tblMemoPeriod")

Signature

Duane Hookom
MS Access MVP

> Dear all,
> In my database, I have a table named tblMemoPeriod, which only stores one
[quoted text clipped - 13 lines]
> Thanks!
> Gary

Reply to this Message