Arrays in Access

  • Thread starter Thread starter Brian C.
  • Start date Start date
B

Brian C.

Is is possible to create an array in an Access table - like 12 months of
sales values for a salesrep?
 
What you would do is create a separate table called tblSales or something
and add the SalesRepID to this new table as a Foreign Key. This will allow
you to create a relationship between the two. Something like this:

SalesRep Sales
====== ======
SalesRepID--| SalesID
LastName |---<SalesRepID
(etc) SalesValue
(etc)

In the SalesRep table, SalesRepID is an autonumber Primary Key. In the
Sales table it is a long integer. (SalesID would be an autonumber primary
key for Sales)
 
So I would need to put in the Sales table the month # (1-12) and then the
sales figure for that month giving me 12 records per sales rep? I suppose I
could also put in the year, ...
 
Absolutely correct! However, I would probably store the month as a
Date/Time field, because there are a LOT of built in Date functions in
Access that give you a lot of flexibility. You would also not need to store
the year then.
 
Good Point!
Thanks Roger

Roger Carlson said:
Absolutely correct! However, I would probably store the month as a
Date/Time field, because there are a LOT of built in Date functions in
Access that give you a lot of flexibility. You would also not need to store
the year then.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

suppose months
Click to expand...
 
Back
Top