Building a query with the content of a field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I'm looking for the possibillity to use the content of a field to create a
query.
What do I mean?
I created a table with a key field an a field called "Formula".
The content of the field "Formula" can be: "<=Date()+(5-Weekday(date()))-25"

When I create a query and want to deside if a record, with a date field, as
discribed in the "Formula", then I want a True, otherwise I want a False.
The query can look like this: ToLate: IIf([cdatetoek] &
[formule],"True","False")

At this moment, I always get a "True", though the cdatetoek is greater then
Date()+(5-Weekday(date()))-25.

Can somewhone give me any advise on this?
 
I don't have a way to completely test this, put I did a similar test and it
worked.
Give it a try and levt me know if it works.

ToLate: IIf(Eval([cdatetoek] & [formule]),"True","False")
 
Back
Top