store an array

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I storign the price an the costo of the financial of a house. How can I store
this data in an access table, and what a type is this data?
 
I storign the price an the costo of the financial of a house. How can I store
this data in an access table, and what a type is this data?

Whenever you want to store multiple values, you need *a second table*
related one to many to the primary table.

I have no idea what you mean by the "price an the costo of the
financial" so I can't be specific, but if you are storing multiple
components of the cost, you need multiple records in a table.

For some introductions to how relational databases work check out

Jeff Conrad's resources page:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

and

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

especially the "Database Design 101" links on Jeff's page.

John W. Vinson[MVP]
 

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

Back
Top