advanced sorting

[davidg]

Hey,
I have a really weird sorting/compare thing I need to do to the database, and I need it to happen automatically as I enter the information. If I'm entering the information for an order, (on the orders template included in Access) I need to compare the information I'm entering into the order form with the previous orders entered into the database to see if the same order has been entered at a previous time/date.
Thanks for your help,
Dave

 

[jarheadjim]

You should be able to use a "find duplicate" query to do what you need. I haven't used one myself, so I don't know how to set it up, but it sounds like what you need.

 

[The_Doc_Man]

If there is VBA code running anywhere, you can also use

DCount( "[myField]", "myTable", "[myField] = """ & Trim$( [myTextBox] ) & """" )

If the count comes back not zero, you have a duplication.