A
Alain
Hi Again,
I would like to know what is the correct syntax for the following function
with 2 criteria as dates, with one date as a criteria, it is working just
good but with 2 dates as creiteria, still getting a syntax,
Also, can it be coded using the Between And instead of the following:
temp2 = DLookup("[Annual OMT]", "Budget BasicRental", "[idbranch]=" & num &
"And [from]>=#" & omtdate & "# And [to]<=#" & omtdate & "#""")
Many thanks in advance
Alain
I would like to know what is the correct syntax for the following function
with 2 criteria as dates, with one date as a criteria, it is working just
good but with 2 dates as creiteria, still getting a syntax,
Also, can it be coded using the Between And instead of the following:
temp2 = DLookup("[Annual OMT]", "Budget BasicRental", "[idbranch]=" & num &
"And [from]>=#" & omtdate & "# And [to]<=#" & omtdate & "#""")
Many thanks in advance
Alain