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

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

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

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
 

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

Top