aussieolie
04-05-2002, 09:02 AM
How do I put multiple autonumbers (with a query) into a numerical field?
Thanks
Thanks
|
View Full Version : putting created autonumbers into numerical fields in a query aussieolie 04-05-2002, 09:02 AM How do I put multiple autonumbers (with a query) into a numerical field? Thanks Pat Hartman 04-05-2002, 09:10 AM For one thing, you can't put multiple numeric values into a numeric field unless you are summing them and storing the total. Technically you could concatenate them in a text field, however, it is NEVER correct to store multiple values in a single field. Do a little reading on database normalization. There are excellent articles in the Microsoft knowledge base and by using the search feature on this forum you should be able to find links to them. |