Recent content by Robinc76

  1. R

    select query

    The code you suggested worked! Many thanks. My table structure was based on the Northwinds database. I'll take a look at your databse to see how it could work for us. Thanks again. Robin
  2. R

    select query

    The two tables and there fields are table: Orders OrderID (primary key) Customer AccountNumber OrderDate Table: [Order Details] OrderID OrderDetailID (primary key) ProductID Description Quantity UnitPrice My SQL is limited so i have only managed to create the query that shows all of the rows...
  3. R

    select query

    OK, i need to query the orders and list the orders that include productID 57 but i also need to list all of the other products on those orders. So, for instance: OrderID 13000 has two products 57 and 58. So the query will pick this up because it includes 57 but i also need to list the other...
  4. R

    select query

    Hi All, I've created a database that we use to manage our sales orders. Two of the tables are 'Orders' and 'orderdetails'. The order table stores the order header info, such as customer name, account number, etc and the orderdetails table stores the products, qnty's, price, etc. They are...
See more
Back
Top Bottom