Manual Input Table

[Richard G]

I want ot design a monthly table which shows each day 1-31 but I want to be able to enter a data value manually for each day.
I'm looking at building a query from the table which asks me for the date ie; 2Aug06 and then asks me for a value ie; 6 so the query (from which I can build my report) shows 02Aug 06 6

Regards

Richard

 

[boblarson]

I think you will want to rethink your design of your table. What you are proposing would be completely un-normalized and, even if you choose not to believe me (or the others sure to chime in), it will only cause you headaches down the road.

Check out the posts on normalization.