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

[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 ?

 

[Duane Hookom]

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?

 

[John Vinson]

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 ?

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