Updating a single record

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

Guest

Help,
I'm new to Access but I've worked through some tutorials. I've got two
tables, Equipment and Repairs. What I need to do is update the Hours field
in Equipment when I make an entry in the Hours field in repairs. The to
tables are linked by Equip Id field.
 
Why?
Just keep the detail in hours table and whenever you need it in a form or on
a report, calculate it. It's poor design to duplicate the information in
another table.

-Dorian
 

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

Another most-recent date query 0
extract 3 numbers from a string 0
Last Repair Record 4
Show only most recent record record 0
Run query or report from multiple tables 5
Need help with a date on a querie, please!!! 9
Adding new records to table via query/form 1
DLookUp or Other Option 7

Back
Top