470,863 Members | 1,093 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,863 developers. It's quick & easy.

Need help with a Date Format Please.

Hi all, I have a situation that is requiring me to make an Entry Date part of the Primary Key. Problem I am having is that it includes the time too.

What I have is an inventory return table.
It consists of 3 fields - Date, Serial #, Model #

Currently I have the Serial # & Model # taged as the Primary key -

But.....

Now I am being told that items might come back more than once...

The primary keys are set to prevent accidental re-entry

If I add the Date to the Primary Key, that should allow for duplication of the item - but not prevent accidental re-entry because the time stamp will always be different. (we use a scanner...so sometimes we get duplicate entries.)

So is there a way to store the date as a date w/o a time?


I am sure this is easy, and probly staring me in the face...but I am at a complete lost.

Thanks,
Sophie
May 22 '07 #1
1 1206
missinglinq
3,532 Expert 2GB
If the date field is actually defined as date/time in Design View of your table, select the field then goto the bottom and click on Format, then select Short Date. How are you actually entering the date?
May 22 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

2 posts views Thread by Mike Button | last post: by
18 posts views Thread by Q. John Chen | last post: by
8 posts views Thread by Lucky | last post: by
9 posts views Thread by pic078 via AccessMonster.com | last post: by
2 posts views Thread by sorobor | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.