Identify if record exists in database
Posted on 2006-06-27
Hard to describe initially in title, but a little background- I have a simple web site setup that allows SSNs and Email addresses to be entered and fed to a SQL Server instance (a date/time stamp is included as well). I am now working on the reporting portion of it which uses linked tables in Access to access the information itself. The intent is to have someone be able to see all the ssns/emails for a given day or time period (I'll handle this portion with VBA in a form), but it should omit any results where the same ssn was already entered at a time earlier than the date range.
Thanks for the help and let me know if anything didn't make sense!