creating a count query from a union query

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.

John Spencer said:
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.


scubadiver said:
How do I?

Any further select query I try based on a union query doesn't work
Click to expand...
Click to expand...
 
Back
Top