Search for duplicate entires

M

Mark H

Hi,
I am trying to get users to input a time sheet on a daily
basis.

Can I pop up an error if the table contains 2 common
items already?
How do I use validate to check on 2 fields?

eg: This user has already entered time for today.
 
M

Mattias Jonsson

Mark, Assuming you have a UserID or similar field, you can add a CreatedDate
field with default value =Date(). Create a unique index called something
like IX_UserDate on the table and include both columns. / Mattias Jonsson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Visio: copy text of a master shape to User-define Cells (Variable) 0
Excel does not accept text format! 0
Duplicate Mail Merge Record Every Time 5
Many sheets, one DB? 1
Duplicated Invoice number checking when leave the field 4
How to find duplicate column (not the cell values) 3
Check for duplicates with multiple criteria 1
Remove Identical words 0

Top