Query indirectly referencing a table

[bugsy]

Not sure if i am wording it right.

In a query i have calculated field that is using Date().
Instead of Date() I want to use a value in a table that only has 1 record.
How can i reference that table ?

 

[CraigDolphin]

Well, you could use the DFirst() function to retrieve the value

eg,

DFirst("[FieldNameHere]","TableNameHere")

 

[bugsy]

Well, you could use the DFirst() function to retrieve the value

eg,

DFirst("[FieldNameHere]","TableNameHere")

great !!!!
thanks

 

[CraigDolphin]

Happy to help