Conditional macro steps

[DSwan]

I use DCount all the time in macros to send emails based on conditions.
Having a problem with one db. In one step the function looks at a query and
sends an email with an attachment if >0, in the next step the function looks
the query and if dcount=0, sends an email saying no records today. So only
one ot the other step is executed. In this particular db it wouldn't do
anything! Since the query is based on a linked table I made the table
internal and now it works fine.

Has anyone else experienced this? Is there some rule that dcount won't work
if the data source is an external table?

 

[Steve Schapel]

... Is there some rule that dcount won't work
if the data source is an external table?

No, there is normally no such rule. I can't think of an explanation.