make table off cross tab

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I'm trying to make a table off a cross tab query, but I can't

It keeps telling me "Circular reference caused by QryXTab". But the QryXTab works beautifully on its own

God I'm having a nightmare with all this crosstab business

Thanks for any tips

Baz
 
You might want to provide your query's SQL view.

--
Duane Hookom
MS Access MVP


Basil said:
Hi,

I'm trying to make a table off a cross tab query, but I can't!

It keeps telling me "Circular reference caused by QryXTab". But the
Click to expand...
QryXTab works beautifully on its own.
 
Thanks for always taking the time to read my posts Duane

For this query, I was actually seeing if I could do a make table off the qxtbtemp query in AtYourSurvey - but it gave me the error. I assumed it was because I was trying to do a maketable qry on a crosstab qry which was based on another crosstab qry

So what I did that worked was to do a make table on the first xtabqry and base the 2nd xtabqry on this newly made table. From this xtabqry it would then let me do a select query which was what I wanted

Basi

----- Duane Hookom wrote: ----

You might want to provide your query's SQL view
 
Back
Top