missmarple
Feb 21, 2008, 03:15 PM
Hi there Whizids!
Can anyone help me as Im at my wits end. I know it can be done but how?
I have created a Table with 5 people. I have used autonumber and only want the one person to appear once in Forms where I have created calculated fields for Quantity price per unit and Total.
But I would like to have more than one entry in this form e.g.. Two / 3 different items with a subtotal then vat and Final Total.
Should I do it in Design view in Datasheet and how?
That's briefly what I want If its not clear ask me and I am only too willing to oblige!
Can anyone help me as Im at my wits end. I know it can be done but how?
I have created a Table with 5 people. I have used autonumber and only want the one person to appear once in Forms where I have created calculated fields for Quantity price per unit and Total.
But I would like to have more than one entry in this form e.g.. Two / 3 different items with a subtotal then vat and Final Total.
Should I do it in Design view in Datasheet and how?
That's briefly what I want If its not clear ask me and I am only too willing to oblige!