Report based on a Query

[Matt Perkins]

I have created a report which runs a query. The query
prompts you to enter a tracking number which is an
Autonumber field. The problem is, the user deleted two
records in the table and now every record after the
deleted ones will not come up when you enter its
Autonumber. The recordes are their, but will not show up
after the query runs based on the Autonumber. Please help!

 

[Larry Linson]

I think you will need to copy the SQL from the Query and post it. Please
clarify here in the newsgroup, not by e-mail. Thanks.

I don't use Parameter Queries as the Record Source for my Reports; instead I
use a Form and a DoCmd.OpenReport with a WhereCondition argument or create
the complete SQL in code.

Larry Linson
Microsoft Access MVP