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: *

  • Users: Kat21
  • Content: Threads
  • Order by date
  1. Kat21

    Adding to a date

    I need to have my query search for a date that a user enters and then it needs to add 4 days because it will run a weekly report. Any help? Ive tried the dateadd function and it does not work.
  2. Kat21

    Here is the code I am using for combining report

    SELECT DISTINCTROW Customer.CustType, Sum([Combined Sales By Customer].UnitsMTD) AS [Sum Of UnitsMTD], Sum([Combined Sales By Customer].SalesMTD) AS [Sum Of SalesMTD], Sum([Combined Sales By Customer].CostMTD) AS [Sum Of CostMTD], Sum([Combined Sales By Customer].SalesPYTD) AS [Sum Of...
  3. Kat21

    Combining for a report

    I am trying to create a combination report that include both site where customers place orders and the sums of each column after. I am having trouble with the join operation. I am getting an error that says customer is not part of an aggregate function. Any help?

Part and Inventory Search

Back
Top