View Single Post
  #1 (permalink)  
Old April 13th, 2012, 07:43 AM
mukta mukta is offline
Registered User
Points: 13, Level: 1
Points: 13, Level: 1 Points: 13, Level: 1 Points: 13, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2012
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Smile 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
Reply With Quote