Recent content by Oucch

For the append query I had opened both tables, when actually all I needed was the temporary one. Pretty simple, but makes a big differece.

Don't worry now solved.

I am trying to change the starting value by running an append query from the following: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3BQ209696 I have entered 999 in field i wish to append, but when i run the query it says "you are about to append 0 rows". Help please.

Umm...im not that experienced at access, could you explain how i go about this? thanks.

How can I set the autonumber to 4 digits? Possibly to start at 0001....this would be much easier.

I tried entering it on the form and hiding, this returns: #Name? I also tried adding it into the append query but had no luck

I have a basic form where the customer fills in; First Name, Surname, Address, Postcode and Telephone. I need to create a unique "customer id" for each person. So once they have filled in the required spaces, i run an append query to the customers table. The "customer id" must consist of the...

I have the following scenario: The company wants a system that will allow customers to go to an introductory form where they must enter the date and time they wish to go on the “Deer Valley Experience”. How can I create a query to match the date and time entered to show only specific seats on...

yeah, i need to be able to view how much total ingredient is required, then I can just update the vat level by taking it away and updating the status of the order.

Instead of the 2 sets (2 orders) I want the batches for each ingredient to add together.

Ok I have uploaded what I have made so far. Just to clarify its the Sum_of_Batches form. Hopefully when you see it, it will make more sense. I want ingredients 1-12 so they dont repeat for each order.

what do you mean, im kinda new to access?

yes basically

I want to take the total ingredients used away from the vat.

The VAT does have a seperate field, a different figure for each ingredient.