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 Mike Lewis 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. mvpkris

    Aggregate Function?

    That worked, thank you! Sorry, but one more question (apparently I am not good at SQL...) it is now giving me this: "Syntax error (missing operator) in query expression 'DISTRIBUTOR_REPORT_INDEX.[INVOICE #] = [000DISTRIBUTORS_MAILTO_BILLTO].[INVOICE #] [000DISTRIBUTORS_MAILTO_BILLTO].BILL_TO"...
  2. mvpkris

    Aggregate Function?

    Sure, here it is, sorry it's not cut properly:: SELECT [000DISTRIBUTORS_MAILTO_BILLTO].BILL_TO, [000DISTRIBUTORS_MAILTO_BILLTO].[INVOICE #], [000DISTRIBUTORS_MAILTO_BILLTO].[PO #], DISTRIBUTOR_REPORT_INDEX.[Due Date], [000DISTRIBUTORS_MAILTO_BILLTO].[QUANTITY1]*...
  3. mvpkris

    Aggregate Function?

    Thanks for the fast response, however I do have an expression "AS TOTAL" at the end of the equation. [000DISTRIBUTORS_MAILTO_BILLTO].[UNIT PRICE7]+ [000DISTRIBUTORS_MAILTO_BILLTO].[SHIPPING] AS TOTAL,
  4. mvpkris

    Aggregate Function?

    I'm trying to set up an equation to multiply unit prices with quantities of multiple units creating a total. I believe the equation is put in to place correctly, however when I try to execute it, i revieved this message: "You tried to execute a query that does not include the specified...
  5. mvpkris

    field list problem

    Thanks a bunch! i was starring straight at it..haha.
  6. mvpkris

    field list problem

    i've created the quiery i would like to grab information from for the report, however i don't remember how to select the quiery to make it the field list. help please! been trying to figure this out for an hour now!!! thanks a bunch! -kris

Part and Inventory Search

Back
Top