hello all 
i am currently doing my AS level ICT and we are oing a database for our coursework, now my teacher is terrible and has no idea about my question so i though i would come here
so here goes....
it is a fairly basic database consisting of 3 tables: Stock, Customers, and Customer Orders.
I also have 4 forms: New Customer entry form, New stock entry form, New order entry form and Front page form.
I have created queries that calculate the totals and VAT etc etc, i have the correct data to create an invoice.
So i have created a report called 'Invoice' which points to the Query 'Total'
this invoice brings up the data of total order cost, total quantity bought, product name, customer name, sales date etc
At the moment, the invoice brings up all the records, so it brings up the orders for every person on one report.
What i want to do is to be able to only bring up an invoice for one customer, so under the query i have put "[ Please Enter Surname Of Customer ]" (without quotes) into the 'criteria' box under the 'surname' record.
this worked perfectly, because everytime i ran the query or the report it brough up a paramter value request for the surname and then this worked with bringing up the right invoice
However i would also like to be able to only do an invoice for a purchase on a certain date, for a certain customer.
For example, if smith bought 4 microphones on 24/6/2010 and then bought 2 mixers on 27/6/2010 how would i be able to display the order for the 27th for the customer smith?
I am a complete noob at databases because we have been taught NOTHING about them, so i am trying to work it out for myself :S
i hope the above makes sense
thanks
ali

i am currently doing my AS level ICT and we are oing a database for our coursework, now my teacher is terrible and has no idea about my question so i though i would come here

it is a fairly basic database consisting of 3 tables: Stock, Customers, and Customer Orders.
I also have 4 forms: New Customer entry form, New stock entry form, New order entry form and Front page form.
I have created queries that calculate the totals and VAT etc etc, i have the correct data to create an invoice.
So i have created a report called 'Invoice' which points to the Query 'Total'
this invoice brings up the data of total order cost, total quantity bought, product name, customer name, sales date etc
At the moment, the invoice brings up all the records, so it brings up the orders for every person on one report.
What i want to do is to be able to only bring up an invoice for one customer, so under the query i have put "[ Please Enter Surname Of Customer ]" (without quotes) into the 'criteria' box under the 'surname' record.
this worked perfectly, because everytime i ran the query or the report it brough up a paramter value request for the surname and then this worked with bringing up the right invoice

However i would also like to be able to only do an invoice for a purchase on a certain date, for a certain customer.
For example, if smith bought 4 microphones on 24/6/2010 and then bought 2 mixers on 27/6/2010 how would i be able to display the order for the 27th for the customer smith?
I am a complete noob at databases because we have been taught NOTHING about them, so i am trying to work it out for myself :S
i hope the above makes sense
thanks
ali