ODBC Fail

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an access database that is connecting to our AS400 through client
access. The connection to the 400 is okay because I can view the linked
table when I open the table in the program. When I write a query on the file
it does not appear to like the Between statement. I say that because when I
just put in one date
 
Looks like you got cut off... but FWIW, the Between...And operator needs two
dates.

Also, the AS400 may not recognize that operator, so you may need to use
greater than and less than symbols instead. <, >, <=, >=
 
Back
Top