table or form creation

[molson2]

I have tried for hours to get this work and I cannot. I need to do this. I
have a list of items I sell for our charity group. I have various items and
various sizes. e.g. Short sleeve t-shirts, long sleeve t shirts, hoody's
etc., size small, medium, large, xlarge, xxlarge for $10 each. I want to put
a name with the order, then add a cost per item, then total all the items
purchsed. I want the final form to look like this.
name item cost per item total # of items total cost
In the end i want the report to say John Smith 1 XLarge and 1 medium SSleeve
tee shirt $20.00 and say 1 hoody Medium $30.00. Then at the end total up all
the items purchased to say total $50.00.
any help would be apprciated greatly. Thanks!

 

[John W. Vinson]

I have tried for hours to get this work and I cannot. I need to do this. I
have a list of items I sell for our charity group. I have various items and
various sizes. e.g. Short sleeve t-shirts, long sleeve t shirts, hoody's
etc., size small, medium, large, xlarge, xxlarge for $10 each. I want to put
a name with the order, then add a cost per item, then total all the items
purchsed. I want the final form to look like this.
name item cost per item total # of items total cost
In the end i want the report to say John Smith 1 XLarge and 1 medium SSleeve
tee shirt $20.00 and say 1 hoody Medium $30.00. Then at the end total up all
the items purchased to say total $50.00.
any help would be apprciated greatly. Thanks!

What you're asking for isn't a table, or a form, but a full-fleged "point of
sale" application. You'll need at least tables for Items, Sizes, Orders,
OrderDetails, Customers. Starting your design with the desired display is
useful to get a broad framework but is NOT how you should start building; you
need to design the tables, first, then their relationships, and then start on
the data entry form; finally you will probably want a Report to print a
receipt.

Fortunately this kind of point-of-sale app is pretty common. The builtin
Northwind sample database has parts of it (directed toward food items rather
than clothing, but you can hopefully adapt it); or you can look on these sites
for further resources:

 

[John W. Vinson]

I have tried for hours to get this work and I cannot. I need to do this. I
have a list of items I sell for our charity group. I have various items and
various sizes. e.g. Short sleeve t-shirts, long sleeve t shirts, hoody's
etc., size small, medium, large, xlarge, xxlarge for $10 each. I want to put
a name with the order, then add a cost per item, then total all the items
purchsed. I want the final form to look like this.
name item cost per item total # of items total cost
In the end i want the report to say John Smith 1 XLarge and 1 medium SSleeve
tee shirt $20.00 and say 1 hoody Medium $30.00. Then at the end total up all
the items purchased to say total $50.00.
any help would be apprciated greatly. Thanks!

Ooops, didn't attach the links:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

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

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

 

[molson2]

Ooops, didn't attach the links:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

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

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

--

John W. Vinson [MVP]
.
John, thanks for that idea about point of sale.

i will look at the links you provided.