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!
--
Thanks for your Help and Patience.
"kim" wrote:
> 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?
|
Similar Threads
