My report does not start with the first record from my table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

My report does not start with the first record from my table. It starts with
the fourth record! Does anyone know how I could fix it so that it would
start on the first record?
 
Forgive me, but I'm really new to Access. Just started using it a week ago.

Not sure if I have an ORDER BY clause. Where is this statement supposed to
be?

I used the wizard to create the report. Not sure where else this would be?
View --> Code?
 
Look at your query that is running the report. For instance, if I had the
following data in a table named People,

FirstName LastName
Jane Johnson
John Doe
Jack Smith

And I wanted to sort this data by the LastName, my query would look like
this,

SELECT FirstName, LastName, HomeTown
FROM People
ORDER BY LastName

Then the records would look like this

John Doe
Jane Johnson
Jack Smith

So when I open my table to view it, it may come up like the top data
example, but when I run a query I can sort these records by any column.

See what I mean?

Drew
 
Keep in mind a report will generally disregard the order of records in your
table or query. If you want to reliably sort a report then use the Sorting
and Grouping dialog.
 
Back
Top