How to set time field in Access so that it stays fixed

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the date and time formats to give me unique numbers which will be
associated with a project name and have managed to insert the expressions for
this individually but I need these fields to retain the numbers and not
change as time and date moves on. Is this possible? Can anyone help?
 
Sharon,

What you want to do is have the PROJECT table with an ID typically set to
autonumber and then any table that needs to link to the PROJECT table you
have that PROJECT ID in the other tables.

Does that help?

Rodger
 
You must log in or register to reply here.

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

How to Migrate IMAP Email to Office 365 Easily 0
Start Time and End Time field templates require dates, not times 1
Access Access - Is it possible to repeat fields in a form? 1
Date field not stay in same format 1
Date-time field in data entry form 3
Combo look up, format from number to text field 8
Time field continues to show date 3
If duplicate value apply conditional format 3

Back
Top