Need all records but the first

[jedder18]

Using Access07

Created a subform where users enter data.
Have an autogenerated number field in the table.
Scenario...

The first data entered will show on a main report.
ANything after the first record needs to show the info on an additional report.

Is their something I can put in the criteria of the autogenerated field[ID]of the query to not show the 1st record?

If the 1st record has a value of 2 in [ID]
I would like records 3, 4, 5, etc only to show up on the additional report and value 2 will show on the main report.

TIA.

Jennifer

Jedder

 

[SkipVought]

Where ID > 2

 

[jedder18]

that was way too easy for you

Thanks..

I've been using Crystal so long, I forget my access coding.



Jedder

 

[dhookom]

I would actually not hard code the value "2" into the query. To get all records other than the minimum ID, I would use something like:

SELECT *
FROM [YourUnnamedTable]
WHERE [ID] <> (SELECT Min([ID]) FROM [YourUnnamedTable])

To get the minimum ID, use:

SELECT *
FROM [YourUnnamedTable]
WHERE [ID] = (SELECT Min([ID]) FROM [YourUnnamedTable])

Duane
Hook'D on Access
MS Access MVP