Search results
-
S
Date range in criteria bring back records out of range??
Hello, I have a query where I have the following criteria in a date column: >=#01/04/2010# And <=#31/03/2011# So, in effect, I want to bring forward all records where this date is between 1st April 2010 and 31st March 2011 HOWEVER, My query is bringing back records with dates such as: 29/04/2011... -
S
If "TableA.FieldA" exists in "TableB.FieldB" then return "1" else "2"
If "TableA.FieldA" exists in "TableB.FieldB" then return "1" else "2" Hi, I need help to enter a field entry in the MS Access 2003 > Query > Design View. Basically, I have two tables, one has a manually entered postcode, the other table has a list of postcodes. I want the query to check the...