thewrightdesign
Registered User.
- Local time
- Today, 10:24
- Joined
- Sep 30, 2010
- Messages
- 85
I spoke too soon LOL. Have put the code into the real database and it's not working like it did in the test database. not sure why, it's done the same. Here is the code that is now not working:
SELECT GEDdata.[DOC#], GEDdata.Lastname, GEDdata.Firstname, GEDdata.Institution, GEDdata.ResultDate, GEDdata.PASS, GEDdata.Score, GEDdata.LAW, GEDdata.SS, GEDdata.SC, GEDdata.LAR, GEDdata.MAT, GEDdata.R, GEDdata.M, GEDdata.L, GEDdata.PLAW, GEDdata.PSS, GEDdata.PSC, GEDdata.PLAR, GEDdata.PMAT, GEDdata.PTOTAL, [Pass:] AS Expr1
FROM GEDdata
WHERE (((GEDdata.Institution)=[Institution:]) AND ((GEDdata.ResultDate) Between Nz([Start:],DMin("ResultDate","GEDdata")) And Nz([End:],DMax("ResultDate","GEDdata"))) AND ((GEDdata.PASS)=[Pass:])) OR (((GEDdata.ResultDate) Between Nz([Start:],DMin("ResultDate","GEDdata")) And Nz([End:],DMax("ResultDate","GEDdata"))) AND (([Pass:]) Is Null) AND (([Institution:]) Is Null));
If I leave anything blank, it will pop up another parameter box to ask for it again rather than seeing it as null and allowing it to be so.
SELECT GEDdata.[DOC#], GEDdata.Lastname, GEDdata.Firstname, GEDdata.Institution, GEDdata.ResultDate, GEDdata.PASS, GEDdata.Score, GEDdata.LAW, GEDdata.SS, GEDdata.SC, GEDdata.LAR, GEDdata.MAT, GEDdata.R, GEDdata.M, GEDdata.L, GEDdata.PLAW, GEDdata.PSS, GEDdata.PSC, GEDdata.PLAR, GEDdata.PMAT, GEDdata.PTOTAL, [Pass:] AS Expr1
FROM GEDdata
WHERE (((GEDdata.Institution)=[Institution:]) AND ((GEDdata.ResultDate) Between Nz([Start:],DMin("ResultDate","GEDdata")) And Nz([End:],DMax("ResultDate","GEDdata"))) AND ((GEDdata.PASS)=[Pass:])) OR (((GEDdata.ResultDate) Between Nz([Start:],DMin("ResultDate","GEDdata")) And Nz([End:],DMax("ResultDate","GEDdata"))) AND (([Pass:]) Is Null) AND (([Institution:]) Is Null));
If I leave anything blank, it will pop up another parameter box to ask for it again rather than seeing it as null and allowing it to be so.