G
Guest
I am doing a stock control database and am having trouble finding the right
expression to use. I am trying to do a query that will show on a form the
amount of values from all records under a certain reference. For instance,
ref: 1020 (being a carpet) may have four different sizes of the same product
in stock (20 sq metres, 8 sq metres, 15 sq metres and 23 square meters) and I
need it to display how many sq metres in total for this product. I also need
it to automatically update as I change the stocks. Can anyone help?
expression to use. I am trying to do a query that will show on a form the
amount of values from all records under a certain reference. For instance,
ref: 1020 (being a carpet) may have four different sizes of the same product
in stock (20 sq metres, 8 sq metres, 15 sq metres and 23 square meters) and I
need it to display how many sq metres in total for this product. I also need
it to automatically update as I change the stocks. Can anyone help?