grouping yields error with recordset

[SunWuKung]

I am assigning a recordset as the recordsource of a Report (the recordset is coming from SQLServer).

The report runs fine but if I try to group on a field in the report I get an error message saying that Access cant find the field I am referring to.

Is there a workaround to this problem - or am I simply messing up something?

Many thanks.
SWK

 

[WayneRyan]

SWK,

Can you "select" the field in a query? If you can't you are
probably referencing it by the wrong name.

Wayne

 

[SunWuKung]

If I run the report withouth grouping the field is displayed correctly, but if I move the same field up to be a group header I get an error message "can't find the field referred to in your expression". The text box has the same name as its control source - all in all it doesn't look like a spelling problem.