where condition within a macro

[kstyles]

I am trying to have a multi clause where condition within a macro. What I am doing is setting up a macro to pull reports for individual persons. If the persons name is blank then I do not want the report to pull.



Here is my initial where condition in the macro:

[General_outstanding Item Query]![Relationship Manager]="Jane Doe"

If I add the Not IsNull at the beginning when I click off the row it is deleted (the Not IsNull) portion.... if I put it after it brings up a box for me to enter a value for the "null" record.

I have entered the values for each individual person because I want to e-mail them their reports seperately in a PDF... I can get their reports to export, but I do not want blank reports...

Any hints?

[kennejd]

Are you trying to see if the report is blank before you generate and email it? I'm not sure how to test that in a macro....but if you use vba, you could test if the records exist for each person. One way would be to use a dlookup function.

[kstyles]

Yes, in a way - I don't even want the report to be generated if it is blank. Would a dlookup still work?

[kennejd]

Yes, it would work or dcount....dcount("fieldname","tablename","[id]=" & [id])

something like that.

if dcount("fieldname","tablename","[id]=" & [id]) > 0 then docmd.openreport....