Search results

Hi, Just after a bit of help please: I'm trying to create a query that counts the number of duplicate records in a table, but that only looks at values outside a set of parentheses, so for example, the table field looks like this: 12345 (ABCDE) And I want to count the number of times 12345...

Hi I wonder if I could ask for a bit of help - I'm trying to import an ODBC data source into a new table, and one of the fields contains quite a lot of text. Access only seems to import a certain number of characters, not the whole text, which I need in order to run the queries I'm trying to...

Hi Forgive me if this seems like a bit of a rookie question - I'm trying to write a query in access that will delete records that have an entry older than a certain date (eg older than 6 months) If possible, I'd like to make it dynamic, so that when you run the query on any given day it...

Hi Forgive me if this seems like a bit of a rookie question - I'm trying to write a macro in access that will delete records that were created before a certain date (eg older than 6 months) Any ideas how I might go about making one? Thanks in advance