New field in query

[robinski]

I have a query which is supposed to collect an ID from an open form. The form IS open.

In this example the ID No is 191 and the result shows an upside down ? in the eight reords and an additional square in the first record

Here is the SQL:

SELECT [Forms]![frmFixedData]![LastNumber] AS ID, tblTemplate.Branch, tblTemplate.[$], tblTemplate.Tickets, tblTemplate.[>100], tblTemplate.[Week Ending]
FROM tblTemplate;

I have a screen grab which shows the result. I am tempted to guess that this is part of some extended character set where 191 is the upside down query mark. Then there is the problem of the extra square in the first record.

Do you have any idea what I am doing wrong?

 

[David R]

I'm not sure what you're doing wrong, but 191 IS the ISO 8859-1 code for the inverted question mark. 190 shows a square box on some fonts, which is likely the problem with your first record?