Search results for query: *

Is there any way to conditionally delete duplicate values by running a delete query? Eg. delete all duplicates (duplicated in field A) where Field B = 2??

Hi all Is there anyway I can use an action query to automatically delete duplicate records and leave one unique record remaining? The duplicate values are only in one field. I have tried to use the find duplicates wizard, but this displays both occurances of the duplicated record, and if...

Is there any way I can create a variable as a recordset, set the variable to an SQL statement and create a message box that displays a list of values returned by a field (or 2) in the SQL statement? Thanks in advanced. Nick

wow! thank you so much Rich, you've saved me a LOT of file relocating! Nick

I am currently creating a project management database which will be stored on a shared drive. Each project that will be logged on the database will have it's own folder on the shared drive where any documents/spreadsheets etc related to that project will be stored. I have created a field in my...

Is there anyway of creating a relationship between tables that will find a close match rather than an exact match to take input errors into consideration? The filed that may contain input errors is an imported text file so validation is not an option. Any ideas? Thanks :-)

I have created 2 sub-forms on a form that are both based on cross-tab queries. The subforms are continouse forms with a sum for each field in the footer. However, only one sub-form correctly calculates the sum, the other says #NAME?. All control sources are spelt correctly because the form...

The database was created and used only in Access 97. It is created by me and then viewed across a network by other users, who are all adding data to various records, but not in anyway changing the design of the database.

Occasionally when some of my databases are opened, I am shown the error message "Unrecognized Database Format", or "Not a Valid Bookmark." Any ideas how to stop this?

I had the same problem, so I always use fix(now()) instead of date(). Never fails!

I beleive a crosstab query will be adequate. Are you comparing a day this year to the same day last year? If so, can you not set a where condition in the crosstab to only display either date() or date()-365. This will give you 2 rows, one with todays figures and one with last years figures...