How to pass multiple value as parameters to MS access Report from MS access sql code
Hi..Eveyone,
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,
dbo_ACTIVITYM1 IMAC
where REL.SOURCE=SD.INCIDENT_ID and
REL.DEPEND=IM.NUMBER and
SD.INCIDENT_ID=SDAC.NUMBER and
IM.NUMBER=IMAC.NUMBER
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.
Advance Thanks
|