Why are these inclcuded in the query when it is run?

[Lou_Reed]

In the attached db please consider the query qryPersonnel. When I ran the query, I got two fields on the tail end of the results named Field1 and Field2. They are simply repeats of


the fields that are already in the query. I am not sure what they are or why they are there. They are clearly not specified in the qryPersonnel or the tables that are used in the query. Exactly what is going on?

Any help appreciated. Thanks in advance.

Respectfully,

Lou Reed

[CJ_London]

They are clearly not specified in the qryPersonnel

I can see them as clear as day (and there are three, not 2). Why do you say they are not specified? You have in fact specified them twice, once by using tblPersonnel.* and again specifically. Since they are specified twice, Access (or any db for that matter) cannot use the same name twice, so uses default names Field0, Field1 and Field2. If you looked at the values returned rather than just the headings it would be very apparent what has happened

[Lou_Reed]

Okay, thanks for your input it was clearly helpful. It is just a Monday morning and it just threw me. My first thought was whattha?

Respectfully,

Lou Reed

[Lou_Reed]

I am sorry, I just do not see it. I am including another db more current than the last one, that has the opposite problem. There are seven fields, but on the first four are shown. The last three : LastName, FirstName and is Deeleted are missing. what is going on?

Respectfully,

Lou Reed

[Lou_Reed]

Is this what you are talking about? What is shown in this screenshot of the design view of qryPersonnel.

What is shown here in the first column? tblPersonnel.*. Is this it.

Is this what is casing all of this.

Respectfully,

Lou Reed

[Lou_Reed]

I have the answer to post 4. The boxes for the missing fields were unchecked. That is why they were not shown.

Respectfully,

Lou Reed

[Lou_Reed]

Can someone answer post #5. I just do not see it. I am wondering how it was fixed in my db. It was fixed, but I think that I stumbled over it.

Why is so much unnecessary stuff (fields) being shown. I did not explicitly ask for it, but it is there. I only asked for seven things, seven fields. I got s lot more than that.

Any help appreciated. Thanks in advance.

Respectfully,


Lou Reed

[CJ_London]

I did not explicitly ask for it, but it is there

you have asked for all fields in tblPersonnel (that is what tblPersonnel.* does) and then asked again for your specific fields - as explained in post #2. If you don't want to see all those additional columns, remove the tblPersonnel.* column

[Lou_Reed]

Including, tblPersonnel.* , was a miskey or mistake. I would never have done that on purpose. It is too easy to make this keyboard error. That is what I thought it was when I looked closely at it.

SO I changed tblPersonnel.* to PersonelID and everything was fine and dandy.

As I said: it is to easy to make that miskey and then not realize that you did it.

Thanks for your help.

Respectfully,

Lou Reed