If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
auto field update
I tring to use the date in one field in a database to update another field in
the same database automaticly (Primary date {field 1} – 280 days =secondary date {field 2}) Please break it down barny style I’m new at this. Thanks |
#2
|
|||
|
|||
auto field update
You don't.
Having a field whose value is completely derivable from values of one or more other fields in the same row is actually a violation of database normalization principles. What happens if you update {field 1} and forget to update {field 2} or vice versa: how will you know which one's correct? The appropriate thing to do is only store {field 1} in your table, and create a query that has a computed field to represent {field 2}. You'd then use the query wherever you would otherwise have used the table. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Will 2823" Will wrote in message ... I tring to use the date in one field in a database to update another field in the same database automaticly (Primary date {field 1} - 280 days =secondary date {field 2}) Please break it down barny style I'm new at this. Thanks |
#3
|
|||
|
|||
auto field update
Is this something your doing one time or are you planning on storing the
date twice in the same datafile? If it is a onetime update you can just run an update query. If you plan on making it a normal feature of your datafile it may not be the best way to do it. To use the update query you will need something in each of the tables that will relate the records together so each date in table 2 is related to a specific record in table 1. As you want it at the Barny level rather than typing it all out check these two sites for instructions, pictures. They don't include music but I suspect you'll still get along... http://www.databasedev.co.uk/update_query.html http://office.microsoft.com/en-us/ac...765271033.aspx Also, rarely is it a good idea to store the same information in one table in another table unless it is used to create the relationship in the datafile. Pete "Will 2823" Will wrote in message ... I tring to use the date in one field in a database to update another field in the same database automaticly (Primary date {field 1} - 280 days =secondary date {field 2}) Please break it down barny style I'm new at this. Thanks |
#4
|
|||
|
|||
auto field update
|
Thread Tools | |
Display Modes | |
|
|