Search results

I've got the query to run but had to tweak it a bit, what is the difference between using HAVING and WHERE? SELECT DATEVALUE([Finished]) AS [FinishDate], Paintshop_tblProduction.PartNo, Paintshop_tblProduction.Description, Sum(Paintshop_tblProduction.[Actual Qty Produced]) AS Total...

so i need to prefix each field with tablename.[fieldname]?

I've changed the 2nd line to now be: DateValue([Finished]) AS [FinishDate], an I'm still getting the same error

Hi can anyone help me with the following query it is giving me this error: "The LEVEL clause includes a reserved word or argument that is misspelled or missing, or the punctuation is incorrect." here's the query SELECT DateValue([Finished]) AS [Date], Paintshop_tblProduction.PartNo...

after a bit of trial and error to fix syntax issues I now have: WHERE ( ( (tblQuantum.DateEntered) Between [forms]![frmReports]![StartDate] And [forms]![frmReports]![EndDate] ) AND ( Cint(tblQuantum.SerialNumber) >= CInt(Assembly_tblProduction.FirstSerial) AND Cint(tblQuantum.SerialNumber) <=...

Hi everyone, I developed a query that acts as a datasource for a report but I need some help with finalising the where clause. the two tables in question have a one to many relationship for example the production table has 1 row of data with these 2 fields: First Serial = 624 Last Serial = 642...