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

F

Frank F.

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