asked on
PARAMETERS [Start Date] DateTime, [End Date] DateTime;
SELECT dbo_NonConfData.CaseDate, dbo_NonConfData.Id, dbo_NonConfCreator.CreatorName, dbo_DefectCategory.DefectCatType, dbo_Vendor.Name, dbo_NonConfData.OrderNum
FROM ((dbo_NonConfData INNER JOIN dbo_NonConfCreator ON dbo_NonConfData.Creator = dbo_NonConfCreator.ID) INNER JOIN dbo_Vendor ON dbo_NonConfData.ProducedBy = dbo_Vendor.ID) INNER JOIN dbo_DefectCategory ON dbo_NonConfData.DefectCategory = dbo_DefectCategory.ID
WHERE (((dbo_NonConfData.CaseDate) Between [Start Date] And [End Date]))
ORDER BY dbo_NonConfData.CaseDate;
ASKER
ASKER
Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.
TRUSTED BY
How, exactly, are you doing this?
In other words, post the entire code you are using to do this...
Does it work if you take out the parameters at the start of the SQL? (and just rely in the Parameters in the WHERE clause)