Search results

I hope I am not trying to accomplish an impossible task.. However, I want to combine 2 queries that give different results. Please see attachment with the task I am trying to accomplish showing the queries and the results. Thanks for any suggestions please.

I have a query that is used to generate a report. When I try to open the query design it gives a message that 'there is a missing ),] or item in query expression'. When I select OK it exits the query. I also tried accessing the query from the report properties, but same problem. How can I...

First I will open a form and choose a salesman. Then based on the salesman selected I want to open a recordset and start searching for the last record for the salesman selected. When the record is found some of the information from that record is pulled on the form.

Access 2000: I have 8 salesmen selling the same 10 items. I also have a sales table with each record showing: (date, salesman) - and for each item (opening stock, sales, closingstock, qtyreturned). To open the daily sales form I first select the date and then the salesman. I have to key in...