June 29, 2006 at 3:44 am
Hi i need a way to flag repeat orders i need to check the serial number and the material number, i will sort the created date and the serial number, how would i go about doing this in access as i've only got it in excel at the moment.
June 30, 2006 at 6:33 am
1st, what are you trying to created (what business process) with this flag. If you're trying to create an automated process for processing reorders then access might not be your best bet since you limited in how to automate the reminder process. You can probably create a macro to check for the flag and send an email reminder to the sales rep. but to keep that process running you need to keep the db open 24/7. You'd probably be better off using SQL Server and schedule daily services that can do the same type of processing.
If your just looking for a flag that you can query against then set a yes/no or true/false field for use in your query.
Regards,
Matt
June 30, 2006 at 7:43 am
You can identify repeat, or duplicate records by creating a query with the "Find Duplicates" query wizard in Access. Here's an example of the SQL generated by the query wizard.
SELECT tblAddress.fkHouseholdID, tblAddress.pkAddressID, tblAddress.Address, tblAddress.City, tblAddress.State, tblAddress.PostalCode FROM tblAddress
WHERE (((tblAddress.fkHouseholdID) In (SELECT [fkHouseholdID] FROM [tblAddress] As Tmp GROUP BY [fkHouseholdID] HAVING Count(*)>1 )))
ORDER BY tblAddress.fkHouseholdID;
The sub-query--the part in the WHERE clause--looks for duplicate values in the selected field (fkHouseholdID). In your case, you'll be looking for duplicate values in the fields "CreatedDate" and "SerialNumber".
Once you identify the repeat orders, you can flag them by updating a field in those records.
George
June 30, 2006 at 8:17 am
Looks like I misread your question. George is correct.
Regards,
Matt
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply