Search results

I have a query in Access which selects records with a date value in between 2 dates from a field called 'Period', e.g. 01 Jan 07 to 01 Apr 07 (>="01 Jan 07" AND <="01 Apr 07") which returns all the records I would expect, i.e all records between 01 Jan 07 and 01 Apr 07. The 'Period' data/values...

I am using CDate to convert a date text string into a date value, which is then listed in ascending order in the result. If I leave the default format as 'dd/mm/yy' the data is in the correct date ascending order when the query runs but if I use - Format(CDate(etc, etc),"dd mmm yy") The query...

I have a database that I suspect has some duplicate entries in it. Rather than using the query avaiable in Access (which only seems to look for duplicate entries in a field) is there something I could use that would look for duplicate entries on all fields used in a record? Thanks

I have a database that I suspect has some duplicate entries in it. Rather than using the query avaiable in Access (which only seems to look for duplicate entries in a field) is there something I could use that would look for duplicate entries on all fields used in a record? Thanks

I have managed to build a macro that will run a query I have in Access but what I would like to do is be able to change some of the query criteria using the macro script or any other way possible. Is this possible? Thanks