creating a count query from a union query

[Guest]

How do I?

Any further select query I try based on a union query doesn't work

 

[John Spencer]

SELECT Count(*)
FROM [Name of Union query]

Does that work?

Also, you know that the column names for a union query are determined by the
first query clause in the Union query.

IF you can, post what you have tried. Also, post what you mean by "doesn't
work". That can mean - you don't get records back, you get the wrong
results, you get a syntac error, etc.

 

[Guest]

Something weird was going on but it seems to have worked now. When I said "it
doesn't work", the query would simply just not open, no error messages or
anything.

I did have a code error problem (which I posted in "general questions"). It
may have had something to do with that.

Apologies for the waste in time responding.

SELECT Count(*)
FROM [Name of Union query]

Does that work?

Also, you know that the column names for a union query are determined by the
first query clause in the Union query.

IF you can, post what you have tried. Also, post what you mean by "doesn't
work". That can mean - you don't get records back, you get the wrong
results, you get a syntac error, etc.

How do I?

Any further select query I try based on a union query doesn't work