Date filed pluss number of days from another table

[Morten R]

I need a litle help to solve a syntax qustion

This is my query:
Forfall: Date()+([svarfrist].[svarfrist])

The case is to use this day' date and add the number in the table "svarfrist". The point is that the user are able to change the nomber of pluss days from time to time.
This qery running, but it only give bad number of days...


Hope somone have the time to give med ab advice.

Morten

 

[RuralGuy]

You may wish to look into the DLookup() function but it will slow down the query quite a bit. Can you use a Join in your query? Then the field from the other table will be easily available to use.

 

[Morten R]

You may wish to look into the DLookup() function but it will slow down the query quite a bit. Can you use a Join in your query? Then the field from the other table will be easily available to use.

Thanx a lot RG, the DLookup() function makes my day
The speed is not wery importante, because its a wery smal db whit only 3-4 000 records and 2 users. Thanx aigen!

 

[RuralGuy]

Glad I could help.