Search results for query: *

There is no need to be hasty. You were both wrong!!! Here is the proper code that works for anyone who may have the same problem I did. You will use it in your where statement WHERE (((weekly1.Expr1)=[FORMS]![weekly]![Month]) AND ((weekly1.Expr2) Between [FORMS]![weekly]![day] And...

Everything works fine I just need to know how to add so I can get a weekly report from the date the user enters. I have tried the functions you supplied me with but they are just returning blank data.

I tried this the dateadd function does not work I am putting it in the criteria for the design mode is this wrong?

Ok I did that so how do I get it to add 4 to the date

PARAMETERS [FORMS]![Weekly]![Date] DateTime; SELECT [DISPOSITION OF SCRAP MATERIAL].Date, [DISPOSITION OF SCRAP MATERIAL].Item, [DISPOSITION OF SCRAP MATERIAL].Quantity, [DISPOSITION OF SCRAP MATERIAL].[Vendor Error], [DISPOSITION OF SCRAP MATERIAL].[Operator Error], [DISPOSITION OF SCRAP...

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.

You don't have to list it on your resume, but that isn't a bad GPA for computer science. If you feel it may hurt you in getting a job don't list it. I didn't and I just showed I had experience and education and recieved the job. Good Luck!

Yes I am using access and I just found out the other query was working but now it is giving me the same error.

Thanks Terry but I am still getting a error that says site is not part of an aggregate function and it doesnt make sense. I am trying to work off another query called Combined Sales By customer is this the reason I am having the problem

I use that and it still tells me that site is not part of an aggregate function. 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...

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

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

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?