Inserting more items in a form

[aym]

Good morning to you all
I design a database that contains the following fields in MS Acess:
1. Items in combo
2. Quantity
3. Unit price
4. Total

I will like to click on a button that will enable me to insert the field above like this
1. Item. Quantity. Unit price. Total
2. Item. Quantity. Unit price. Total

Grand Total. TOTAL
continously and it should give me the grand total.
Thanks for you usual assistance

 

[June7]

Have you built a form?

Textboxes can have expressions to do calculations.

This is really basic Access functionality. Have you studied an introductory tutorial book?

 

[vba_php]

I design a database that contains the following fields in MS Acess:
1. Items in combo
2. Quantity
3. Unit price
4. Total

I will like to click on a button that will enable me to insert the field above like this
1. Item. Quantity. Unit price. Total
2. Item. Quantity. Unit price. Total

to get records to show up vertically, one repeated after another in a form, just set the default view to "continuous" in the properties. to get a [total] field, write a query and add a field with a statement like:

table.quantity * table.unitprice

Grand Total. TOTAL continously and it should give me the grand total.

perhaps something like this in a textbox's control source property (textbox located in the form footer)?

=dsum("total","queryNameHere")

Have you studied an introductory tutorial book?

agreed. but I would recommend u google ur litter heart out and search ms access online forums for FAQ pages and stuff, NOT read a book.

 

[Galaxiom]

perhaps something like this in a textbox's control source property (textbox located in the form footer)?

=dsum("total","queryNameHere")

Better to just Sum the Total field from the form's recordset with a textbox in the form's footer. It saves running the same query again.

=Sum([Total])

 

[aym]

Thank you for your respond, I will work on it. Thanks

 

[aym]

Post Re: Inserting more items in a form
Thank you for your respond, I will work on it. Thanks

 

[aym]

Better to just Sum the Total field from the form's recordset with a textbox in the form's footer. It saves running the same query again.

=Sum([Total])

Pls how do I continue to Add item, Qty and Unit price maybe by clicking on a button called Add Item. So by clicking on the button the following should be display: Items (Combo), Qty, Unit Price, and the total. Thanks

 

[mike60smart]

Hi

Can you upload a zipped copy of your Database?

 

[theDBguy]

Pls how do I continue to Add item, Qty and Unit price maybe by clicking on a button called Add Item. So by clicking on the button the following should be display: Items (Combo), Qty, Unit Price, and the total. Thanks

Hi. You could try this. Go to design view of your form and add a button using the wizard and select record navigation, go to new record.