Building a work order form.

[Kelly B.]

Hello

I've created a customer database for the company I work for. Now I've
started on building a work order, which will be related to It.
Basically, I need to build a form to accept shirt size quantities,
subtotals and totals. To accept these orders I need about 12 rows and
several columns of information. I tried using a spreadsheet in excel
and the datasheet view in Access, but I keep getting just the names of
the columns and one row. How do I get more than one row? It would also
be helpfull to know how to tell access to add up my quantities,
multiply it by a given price and supply a total cost. I've discovered
how to make it multiply but not how to add up the quantities of shirt
sizes. I know these questions may seem simple to some, but I am
actually a graphic designer trying to stay employed over the winter. I
have no experience with spreadsheets.
Please Help!

Thanks much!

[TC]

Building a database is >totally different< to building a spreadsheet. An
Access datasheet might >look like< a spreadsheet, but it is based upon a
totally different set of design principles.

Start by reading:
http://support.microsoft.com/support...es/Q100139.ASP

HTH,
TC
"Kelly B." <RB*****@sceinet.com> wrote in message
news:44*************************@posting.google.co m...

Hello

I've created a customer database for the company I work for. Now I've
started on building a work order, which will be related to It.
Basically, I need to build a form to accept shirt size quantities,
subtotals and totals. To accept these orders I need about 12 rows and
several columns of information. I tried using a spreadsheet in excel
and the datasheet view in Access, but I keep getting just the names of
the columns and one row. How do I get more than one row? It would also
be helpfull to know how to tell access to add up my quantities,
multiply it by a given price and supply a total cost. I've discovered
how to make it multiply but not how to add up the quantities of shirt
sizes. I know these questions may seem simple to some, but I am
actually a graphic designer trying to stay employed over the winter. I
have no experience with spreadsheets.
Please Help!

Thanks much!