Update Query - daily update of 31 fields (each day of month)

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

Guest

Have table that contains 31 fields, one for each day of the month. Can create
31 update queries to update each day. Is there a way to have one update
query with variable key-in to indicate which day field to update ?
 
Can you provide a justification for this type of structure when you can
possibly keep your data normalized and display your data as 31 different
fields/columns when needed?

If this isn't possible, could you provide some sample records?
 
Have table that contains 31 fields, one for each day of the month. Can create
31 update queries to update each day. Is there a way to have one update
query with variable key-in to indicate which day field to update ?
Click to expand...

No. That's one of MANY reasons why storing data (day of the month) in
fieldnames is considered bad design.

Any chance you could store a tall-thin table with two fields, a
date/time field and the value for that day; and use a Crosstab query
to *display* the data in this format?

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top