i am having 2 tables
1> name, passportexpirydate
2> Expiryname, duration
1> aaaa , 02-02-2008
bbbb , 02-05-2009
cccc , 07-08-2024
2> passport , 60
visa , 30
insurance , 15
i have a text box in the form which should display the count of the name for whom the passport is going to expire in the mentioned duration from today.
count = (datenow - date of expiry) >= 60
how can i acheve this using d look up..
at present i am hard coding 60
=DLookUp("Count([Date of Expiry])","[Honeywell Travel Tracker]","[Date of Expiry]<(Now()+60)")
but that 60 needs to be fetched from another table. pls help me out with this issue.
1> name, passportexpirydate
2> Expiryname, duration
1> aaaa , 02-02-2008
bbbb , 02-05-2009
cccc , 07-08-2024
2> passport , 60
visa , 30
insurance , 15
i have a text box in the form which should display the count of the name for whom the passport is going to expire in the mentioned duration from today.
count = (datenow - date of expiry) >= 60
how can i acheve this using d look up..
at present i am hard coding 60
=DLookUp("Count([Date of Expiry])","[Honeywell Travel Tracker]","[Date of Expiry]<(Now()+60)")
but that 60 needs to be fetched from another table. pls help me out with this issue.