report sequence changing when saved as .rtf

[dogdays]

win 732 access 2003
I have a report whose record source is

SELECT * FROM tblTemplateFiscalGiftsRecapj  ORDER BY tName ASC

The report is in the correct sequence on the screen, but when I save the report as as an .rtf the sequence reverts to the primary key. Advice appreciated.

tia Jack

 

[boblarson]

Sounds like you might have a lookup defined at table level on tName. Is that correct? If you do, you should not have that as it can cause problems just as you describe. Or, if you are using multi-valued fields and tName is one of those then it would require a different handling of the SQL statement.