Page Break based on First Letter Not working

[fsupport1600]

I have a report based on the following Query:

Field: prodTagID
Table: tblProducts

Field: RoomNumber
Table: tblRooms

Field: Quantity
Table: tblFunitureSelection

The report is grouped on prodTagID. The product tags contain the following values: A101, A102, B101, B102, C101, etc.

I want to have a page break at each new product tag letter.

In the report under the Query builder I added the following:

Field: FirstLetter: Left([prodTagID],1)
Table: "blank"

When I go to run my report, I recieve an error:

"The specificed field '[prodTagID]' could refer to more than one table listed in the FROM clause of your SQL statement.

Is their another way I have have this report page break on each new letter, A, B, C, etc.

Any help is appreciated.

 

[fsupport1600]

I changed the query syntax to:

FirstLetter: Left([tblProducts
.prodTagID],1)

Works now.