Problem with Record Sources

[MNtoAZ]

My boss has requested a report to show our department's productivity and I am have having troubles building one! The first problem is that I am not the person who set up this database and they are no longer with us.

I am trying to build a report through the report wizard, however when I click finish it tells me, "You have chosen fields from record sources which the wizard can't connect. You may have chosen fields from a table and from a query based on a table. If so try choosing fields from only the table or only the query."

I am selecting only queries... if the query was based on a table how do I fix that so it shows up in my report?

Any assistance in this matter is appreciated!

 

[MNtoAZ]

I forgot to mention I am using Access 2000

 

[MNtoAZ]

My access for dummies book conveniently doesn't discuss record sources, I also wasn't able to find a thread that addressed this problem.

 

[ajetrumpet]

I am selecting only queries...

Are you selecting more than one query? Do you have stacked queries in the mix? Some queries are based on others, thus an overlap in the same fields..

 

[MNtoAZ]

Yes, I have about 6

 

[ajetrumpet]

the first thing to do then would be to see if you're selecting any fields that would cause the error message..

 

[MNtoAZ]

There is one specific field that is causing the error message.... I think I set it up through a table and not a query

 

[MNtoAZ]

I have no idea how the other queries were set up and there are no tables for the report I need. I am so lost I really have no clue what I am doing...

 

[thatlem]

When you build a report, right click on the upper left-hand corner box and select properties. On the data tab, you will see the control source. That source needs to be the name of the query from which you are pulling the data fields. Having said that, all the fields that you need to pull, need to be within that single query. If you have multiple queries or tables from which you need to pull fields, you must first pull those fields into this one query. Test the query. If all the fields in the query pull as you expect, then when you run the report, you should not get any errors. The only issue I have previously run into is multiple stacked queries, in which you pull fields from a query previously pulled from a query, etc. My experience is that you can only successfully run a report from no more than two stacked queries. Ie. Main Table > Master query > 2nd Query > Report.

Hope this helps.

 

[gemma-the-husky]

are the tables connected properly - a linked table will have an arrow (accesstable) or a world (SQL) symbol.

if you have any of these try to open them by directly opening the table

if the linked database no longer exists/cannot be found/etc , this might be the problem

 

[MNtoAZ]

Well it looks like the tables are NOT connected properly and I was trying to run a report from 5 stacked queries. ARG!