Search results

Thanks. That worked, thank you guys again for all your help.

I'm curious why this isn't working. DELETE "*" FROM before_deleteQuery WHERE (("Current_Date"-before_deleteQuery.dateCreated)<30); I am getting a data type mismatch error.

Well, yes I'm sure. I understand your apprehension, however, this database is simply a small database that we import data from a larger into, it does not need to be kept as it takes only minutes too import the data, build the tables and do what needs done.

Actually that is exactly what I meant. I am building a database to use for some larger mail merge applications. I would like to exclude (among other things) all accounts that have been opened within the last thirty days as they do not qualify for the offer we are mailing out. I will let...

I would like to delete records using a sql statement and comparing dates. The dates will be current date and creation date. Creation date will be imported into the table from another database. Obviously the current date will be rendered by the system. I would like to delete all records...

hooray Thanks for your time that worked like a charm. All Hail The Internet Guru's.

cont. the acct field is of the number data type. It is not important which of these is kept as they were brought in solely to use as a unique identifier for the table. The custNumber is the field that has the duplicates in it so I would assume the query would be focused on that field, right...

A little mistake. My apologies but there is no idea field. The account number is defined as the primary key as it has no duplicates. So ex out the ID number and imaging account number as the primary key field, and no the acct field is not an auto-number it was a part of the import from...

I am using information pulled from a separate database to create a new database for mail merger purposes. I have created delete queries that go out and delete specific records from the new database to help us get the proper list before setting up the mail merge. However, now I am stuck. We...