Access query help

[greektony]

I hope someone here can point me in the right direction.

How do i get an Access query to report on any records AFTER the first 10. I have a table with 10s of records in it. I basically need a report which shows the top 10 records and then have a line with other which is all remaining records summed together.

Any help would be much appreciated as this is doing my head in, and google is being much help

Cheers

[Steve]

LIMIT 20,30 would show the next 30 records after record 20, methinks... as an example.

[streetster]

is there a way of doing the whole

"select top 10 table.field from table"

thing for the top 10, and then 'subtract' that from

select * table.field from table, in order to get the rest?

[greektony]

thanks for the suggestions guys.....I managed to get the results I wanted from an unmatched query Thanks anyways though

[Moby-Dick]

SELECT fields FROM table where fields NOT IN (SELECT TOP 10 fields FROM table)

would do it ( if I got the formatting correct )

[streetster]

SELECT fields FROM table where fields NOT IN (SELECT TOP 10 fields FROM table)

would do it ( if I got the formatting correct )

thats what i was talking about, just using the right syntax and slightly more brain power

[greektony]

new problem now access gurus....... is it possible for an Access 2000 REPORT to display data from more than one query.

I am looking to display the top 10 records as 10 individual lines then with a line for other items which would be the total of the records not in the top 10. Followed at the bottom of the page with a total line which would add all the lines above it together.

All and any help is much appreciated

[Moby-Dick]

Not sure about access report design so I can't remeber where you put the underlying SQL into it