Export query if not null

[Jason]

I am using a Transfer text macro to export the results of
a bunch of queries to text files.

However, I dont want it to create the file if the query
returns no results.

What do I have to put in the condition box of that line
for this to happen?

I tried:

Is not null ([Query Name]![Field Name])

but that didn't work.....

 

[Ken Snell]

DCount("*", "Query Name") > 0

With above condition expression, the macro action will run only if there is
at least one record in the query.

 

[Jason]

Thank you!!!

-----Original Message-----
DCount("*", "Query Name") > 0

With above condition expression, the macro action will run only if there is
at least one record in the query.

--
Ken Snell
<MS ACCESS MVP>

I am using a Transfer text macro to export the results of
a bunch of queries to text files.

However, I dont want it to create the file if the query
returns no results.

What do I have to put in the condition box of that line
for this to happen?

I tried:

Is not null ([Query Name]![Field Name])

but that didn't work.....

.

 

[Ken Snell]

You're welcome.

Thank you!!!

-----Original Message-----
DCount("*", "Query Name") > 0

With above condition expression, the macro action will run only if there is
at least one record in the query.

--
Ken Snell
<MS ACCESS MVP>

I am using a Transfer text macro to export the results of
a bunch of queries to text files.

However, I dont want it to create the file if the query
returns no results.

What do I have to put in the condition box of that line
for this to happen?

I tried:

Is not null ([Query Name]![Field Name])

but that didn't work.....

.