Query with extra fields

JaredNJames

Registered User.
Local time
Today, 11:24
Joined
Jul 7, 2007
Messages
87
hi, i have a query which gives the number of items to be reordered.

basically it opens a form which displays the item name and how many to order.

i want it so that the user can add an additional number of each item and then have it total them for the user.

example:
item: bulb
to order: 3
additional: 2
order total: 5

my problem is that the form is in a tabular layout, and i
a) cant work out how to get two boxes extra on the form to enter the information
b) cant get the information to a report to print

jjames
 
additional:
i can put text boxes on, but when i enter additional numbers to order, it sets that number down the entire coloumn for every item.

jjames
 

Users who are viewing this thread

Back
Top Bottom