Quick Query Problem

  • Thread starter Thread starter dannie
  • Start date Start date
D

dannie

PARAMETERS [Forms]![Main Form]![cmbArea] Text ( 255 );
SELECT InspectionsDI.ID,InspectionsDI.Area
FROM InspectionsDI
WHERE InspectionsDI.Area=Forms![Main Form]!cmbArea;

This code works correctly for each individual area but I also want to allow
all the records to show if Forms![Main Form]!cmbArea = "ALL"

I am not sure how to do this, I tried If statement but my syntax must have
been wrong, thanks for help.
 
Try this --
PARAMETERS [Forms]![Main Form]![cmbArea] Text ( 255 );
SELECT InspectionsDI.ID,InspectionsDI.Area
FROM InspectionsDI
WHERE InspectionsDI.Area Like IIF(Forms![Main Form]!cmbArea = "All", "*",
Forms![Main Form]!cmbArea);
 
PARAMETERS [Forms]![Main Form]![cmbArea] Text ( 255 );
SELECT InspectionsDI.ID,InspectionsDI.Area
FROM InspectionsDI
WHERE InspectionsDI.Area=Forms![Main Form]!cmbArea OR
Forms![Main Form]!cmbArea="ALL";
 
This code works correctly for each individual area but I also want to allow
all the records to show if Forms![Main Form]!cmbArea = "ALL"

I am not sure how to do this, I tried If statement but my syntax must have
been wrong, thanks for help.
Click to expand...

PARAMETERS [Forms]![Main Form]![cmbArea] Text ( 255 );
SELECT InspectionsDI.ID,InspectionsDI.Area
FROM InspectionsDI
WHERE InspectionsDI.Area=Forms![Main Form]!cmbArea
OR Forms![Main Form]!cmbArea = "All";
 
Back
Top