Report Designer Could not convert

[BRobinsonS]

When doing a Review in Report Designer, I get the message

Could not convert variant of Type (String) into Type (Double)

Not sure why I am getting this message. Several string fields, some currency, and totals.
My suspect that Report designer is try to do a calculation with string or perhaps formatting is incorrect but I get the correct numbers.

When I run the report under with Neobook, the report works ok but I get a message "Bookmark Invalid" when I close the report.
I think it may be related to the Report and not a database table bookmark.

Your thoughts?

[BRobinsonS]

Found Report Designer field causing the 'could not convert' message.
I deleted the field and re-did the field and message went away in preview in design mode.

But still haven't found the cause of 'Bookmark invalid' when I close the report.

[Neosoft Support]

Make sure your database has at least one Primary Key field. If you don't have one, create an AutoInc field and set it as the Primary key. MS Access databases don't work well when there is no primary key field.

[BRobinsonS]

I know AutoInc Primary has been suggested before.
Most the tables have AutoInc Primary fields in this app.

Should all the tables have them?

[Neosoft Support]

Yes, I recommend that all tables have a primary key field. Not having one is usually the cause of the bookmark error.