Arrays in Access

[Brian C.]

Is is possible to create an array in an Access table - like 12 months of
sales values for a salesrep?

[Roger Carlson]

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)

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

"Brian C." <cro...@telus.net> wrote in message
news:l0Z9c.22782$wg1.17190@edtnps84...

[Brian C.]

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, ...

"Roger Carlson" <NO-Rog3...@hotmail.com> wrote in message
news:OF%23cEWbF...@tk2msftngp13.phx.gbl...

[Roger Carlson]

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

"Brian C." <cro...@telus.net> wrote in message

news:RtZ9c.23155$wg1.13408@edtnps84...

[Brian C.]

Good Point!
Thanks Roger

"Roger Carlson" <NO-Rog3...@hotmail.com> wrote in message

news:%23fzArtb...@TK2MSFTNGP11.phx.gbl...