Recent content by Markand

If I have a quantity of items and a cost per item using a querie I can calculate the value of items sold. If I have 10 seperate items how do I sum the 10 values to give a figure for total sales to add to a report. The spreadheet equivalent is the @sum function. I'm only a Noob to access and have...

On the same form some data is customer related, and is therefore stored in the customer table, Some is product related and stored in the products table, order info is stored in the orders table. The information is not repeated, its is unique information input into a single form which sends the...

I have created a form which insets data into 5 seperate tables. Is it possible to duplicate a record in form view rather than copy and paste the record in each of the 5 tables respectively. Any suggestions gratefully received.

Thanks very much. You've saved me hours or work re-writing forms!!!

Could anyone please help!!! I have created a form but in hindsight forgot to add a column to the table I created the form from. I have created the new column in the table, but when I go back into the form the field list does not update with the new column heading. I have tried creating a new...