Re: Functions with Dlookup?

"Douglas J. Steele" <NOSPAM_djsteele@xxxxxxxxxxxxxxxxx> wrote in
news:#VU2tqIEHHA.3596@xxxxxxxxxxxxxxxxxxxx:

That should work. You sure iMonth is the correct value? Is VanID a
text field? (If so, you need quotes around the value).

BTW, Date is a bad choice for a field name: it's a reserved word, and
using reserved words for your own purposes can leads to lots of
problems.


You're right it does work now. I changed a couple of things, one being
changing the field Date to EntryDate.

Thanks
.

Relevant Pages

  • Re: Dlookup and update not working correctly
    ... resources you would recommend for figuring out this kind of syntax? ... You need to put the variable outside the quotes. ... reserved word and will be confused with the VBA function. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Functions with Dlookup?
    ... Is VanID a text ... you need quotes around the value). ... BTW, Date is a bad choice for a field name: it's a reserved word, and using ...
    (microsoft.public.access.gettingstarted)
  • Re: Making use of a Passed Argument
    ... you are passing it the literal string "ServiceN". ... quotes, it will pass the value of the variable. ... You shouldn't name any of your fields or any other object with a reserved word. ...
    (microsoft.public.access.formscoding)
  • Re: Date format to display month name
    ... just put full quotes around the ... (a Reserved word) ... except in your labels and captions ...
    (microsoft.public.access.queries)
  • Re: Is "From" a legal col name.
    ... This is not really a java question, but java is my platform so I'm ... Is "From" a legal column name? ... if you use a reserved word as an identifier you have to quote it with double quotes: ... Note that most DBMS are case-sensitiv when using double quotes, so maybe in your case it should read: ...
    (comp.lang.java.databases)