creating query- 'record sources which the wizard can't connect'

[Guest]

I'm trying to create a query using the wizard based on other queries. A
message appears telling me that i 'have chosen fields from record sources
which the wizard can't connect.'- I know that i have NOT chosen fields from
both a query and a table in that query, and am sure that the queries are
there as i can open them and see the firlds with the data in- just wondering
what else it could be that i am doing wrong?

 

[Guest]

Kim,

I have hit that many times as I have been learning. I usally get around it
by checking my relationships to see if I forgot to establish them or they
were incorrect, and then sometimes I create a small query through the wizard
for just the main table I am requesting data from, and then in query design I
add the other tables and build the final query that I originially wanted. I
think the wizard sometimes doesn't see the relationship(s) that we see.
Though most of the time I think it was I hadn't set something up correctly in
table design or relationship window. Maybe a MVP will correct anything I have
said that is incorrect. So don't give up on that query. Just try it again in
a smaller step.
Example:
I built six small querys (one to get fridays sales by locations, saturdays
sales, sundays sales, and three more for the previous years same fri,sat,sun.
I then tried several times to get all six queries to feed into one master
query for a report. It runs everyweek now in production. But it was a big
learning curve, that paid off. I was trying to convert something that was
being done manually through Excel spreadsheets linked together into a Excel
report. I had created a new access database with detail records that would
feed the access report, that had to look like the Excel report.

Small steps first.
Good Luck!

 

[John W. Vinson]

I'm trying to create a query using the wizard based on other queries. A
message appears telling me that i 'have chosen fields from record sources
which the wizard can't connect.'- I know that i have NOT chosen fields from
both a query and a table in that query, and am sure that the queries are
there as i can open them and see the firlds with the data in- just wondering
what else it could be that i am doing wrong?

The wizard isn't very bright. Why not simply construct the query yourself? Add
the queries that you're trying to join, and drag the joining field from the
"one" side to the corresponding field in the "many". It's possible that one of
your queries didn't include the joining field needed to connect to the other
query.

John W. Vinson [MVP]