p2p.wrox.com Forums

p2p.wrox.com Forums (http://p2p.wrox.com/index.php)
-   Access (http://p2p.wrox.com/forumdisplay.php?f=18)
-   -   How to pass multiple value as parameters to MS access Report from MS access sql code (http://p2p.wrox.com/showthread.php?t=87247)

mukta April 13th, 2012 07:43 AM

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


All times are GMT -4. The time now is 07:00 PM.

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.