Search results

  1. B

    Combining queries

    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.
  2. B

    Cannot open Access 2000 query

    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...
  3. B

    Searching a recordset starting from the last record to the first

    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.
  4. B

    How to show information for a previous record on a current 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...
Back
Top Bottom