Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Queries / March 2006

Tip: Looking for answers? Try searching our database.

Building a query with the content of a field

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Amduke - 23 Mar 2006 15:16 GMT
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?
Klatuu - 23 Mar 2006 16:41 GMT
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")

> Hello,
>
[quoted text clipped - 13 lines]
>
> Can somewhone give me any advise on this?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.