How to pass multiple value as parameters to MS access Report from MS access sql code
PLZ can you tell me How to pass multiple values as parameters dynamically to MS access database Report from MS access sql code.
My sql code is are as follows:
SELECT DISTINCT IM.NUMBER,SD.open_time
FROM dbo_INCIDENTSM1 SD , dbo_SCRELATIONM1 REL, dbo_PROBSUMMARYM1 IM ,dbo_ACTSVCMGTM1 SDAC,
where REL.SOURCE=SD.INCIDENT_ID and
In above code I want to pass multiple values as parameters dynamically to three fields.Like IMAC.Type & IMAC.Operator & SD.Affected_ITEM
It should ask multiple values at run time..when we execute query.
Plz do needful help ASAP.