Simple calculation won't work

[wcrimi]

I feel almost embarrassed to ask this, but I can't get it to work.



I have a series of queries that are input to each other. The next to last one is a Query called ShipperAll4. Within ShipperAll4 some fields are grouped. It produces a count of one of the other fields. That field is called Official Finish Position. I use ShipperAll4 as input to a final Query. I want to use that count field as part of some calculations.

Here's a very simple one. It just adds 1 to the value. The "CountOf" is put in front of the field by Access.

testfield: (([CountOfOfficial Finish Position].[ShipperAll4])+1)

Whenever I run that final Query, it prompts me to enter a value for parameter CountOfOfficial Finish Position.ShipperAll4. I guess it's not recognizing it.

Note: there is also a field input from ShipperAll2 with the name CountOfOfficial Finish Position. That's why I am specifying where the field is coming from.

Thanks

[orange]

I suggest you post the sql so readers can see what you have.

[wcrimi]

SELECT ShipperAll2.RCTrack, ShipperAll2.Track, ShipperAll2.[CountOfOfficial Finish Position], ShipperAll4.[CountOfOfficial Finish Position], ShipperAll2.SumOfWin, ShipperAll2.SumOfPlace, ShipperAll2.SumOfShow, (([CountOfOfficial Finish Position].[ShipperAll4])+1) AS testfield
FROM ShipperAll2 INNER JOIN ShipperAll4 ON (ShipperAll2.RCTrack = ShipperAll4.RCTrack) AND (ShipperAll2.Track = ShipperAll4.Track);

[wcrimi]

Let me ask this question another way.

If I have QUERY that groups some fields and does a count (which is working fine by the way), can I then use that query as input to another query and access the count field?

That's all I am trying to do.

If the answer is yes, that would suggest my problem is some kind of syntax error even though I can't figure out what it is.

[orange]

You could create a recordset using your query as the source, then in vba
reference YourCountfield using something like

Debug.Print rs!YourCountField 'to output the count to the immediate window.

You could also do further processing/display using rs!YourCountField

[wcrimi]

I solved this problem. You can delete this thread. Stupid mistake. Sorry and thanks.