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

Thanks everyone for your input. it is the little things like this in the world that drive us/me potty so is much appreciated :-)

Thought that may have been the case, but by using the CDate function I thought Access would have interpretted the result as a date.......

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

Great stuff!!!

Sorry, I quickly put the initial thread together. I have a table with 8 field of which I want to use 4 of them to check for duplicates. These four fields, when put together, should form a unique string that I would like to check.

Ok, I have managed to run a query that concatenates the 4 fields together but when using design view it doesn't seem to like me using the count function in next column.

I only want to check 4 of the 8 fields in the table.

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