Search results

OK, I've found the error - a very sill one too! My criteria included an 'OR' in the criteria - and this was bringing back the records where date out of range. So, all is working okay now. Thanks for the responses though! Regards, S

Thanks, yes all dates seemed to reformat correctly - but still the dates out of range are showing.

Thanks, just tried this - still same problem...

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...

Re: If "TableA.FieldA" exists in "TableB.FieldB" then return "1" else "2" Many, many thanks - this worked really well :-)

Re: If "TableA.FieldA" exists in "TableB.FieldB" then return "1" else "2" I know I sound thick - but what do you mean by a function in Module1? All I know about are tables and the query.

Re: If "TableA.FieldA" exists in "TableB.FieldB" then return "1" else "2" Many thanks MStef, can I ask where the 'FieldAB' comes from/what does it reference in the query? I can't see it in the tables.

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...