|
Home > Archive > MS Access project with SQL Server > April 2005 > dlookup with date field as parameter in ADP
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
dlookup with date field as parameter in ADP
|
|
|
| I have a from with two text fields field1 and field2. I have one table
"table1" with two fields: date (datetime) and period (numeric). I want the
period to be return in the field2 when I key the date in field 1. I tried
Dlookup("period","table1","date = #" & [field1] & "#") but it doesn't work in
ADP. I tried in MDB and it works. . . . any Idea ???
Thanks
FRED
| |
| Sylvain Lafontaine 2005-04-14, 8:25 pm |
| Use single quotes around the date instead of #.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
"FRED" <FRED@discussions.microsoft.com> wrote in message
news:FDE4DE3E-BF3E-4BD7-89C9- B18F4CA69828@microso
ft.com...
>I have a from with two text fields field1 and field2. I have one table
> "table1" with two fields: date (datetime) and period (numeric). I want the
> period to be return in the field2 when I key the date in field 1. I tried
> Dlookup("period","table1","date = #" & [field1] & "#") but it doesn't work
> in
> ADP. I tried in MDB and it works. . . . any Idea ???
>
> Thanks
>
> FRED
|
|
|
|
|