Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. MarySan1

    Trying to total the quantiy and unit price

    I am using access 97. In the design view of the query, I want to total the quantiy of product times the price per unit to get a total of the invoice. Can anyone help me with writting this expression?
  2. MarySan1

    how to create query of customers with a certain last order date

    thanks, tom that was very helpful and I used your suggestion for the design view and it worked.
  3. MarySan1

    how to create query of customers with a certain last order date

    how do I put this condition into the sql? I'm trying and it's telling me the syntax is invalid. Where exactly do I place this and do I use it as an expression?
  4. MarySan1

    how to create query of customers with a certain last order date

    WHERE DO I PUT THIS CONDITION? i'M NOT VERY EXPERIENCED IN QUERIES
  5. MarySan1

    how to create query of customers with a certain last order date

    here is the sql SELECT DISTINCTROW Customers.CompanyName, Customers.Name, Customers.Address, Customers.city, Customers.state, Customers.SecPhone, [Order Details].ProductID FROM ((Customers INNER JOIN (Employees INNER JOIN Orders ON Employees.EmployeeID = Orders.EmployeeID) ON...
  6. MarySan1

    how to create query of customers with a certain last order date

    I want to create a query that will return me the customer name, address, telephone #, city, state and zip and the product they ordered. I want to be able to also select a certain dates that the last order was placed. I have a query set up already, but when i put in a specific last order date...

Part and Inventory Search

Back
Top