skip the first record?

  • Thread starter Thread starter jim lo
  • Start date Start date
J

jim lo

hi,
i want to know any method to print report that can skip
the first record? either by VBA, or SQL statement...

for example, my sql is sth like this...
"select top 3 name, title from officer order by name"
and it returns followings...
name title
============
Brian programmer
jim engineer
sandy project manager

however, iwant to print only jim, sandy records on the
report. how can i do that?

i watched "Report.NextRecord" API but not work. are there
any method to skip a record when generating report?

actually, if there is rownum function access's SQL, i can
use "..where rownum > 1 and rownum < 4" to do that.

so, any help?
 
?WHERE IndividualName <> "Brian"?

By the way, if your field is truly named "Name", both you and Access will
end up with headaches. This is a reserved word in Access.
 
no... not related to "Brian"...
what i want is to skip the first record!!!

my reason is, the first record has been used in other page
in the report with different page format...
exactly, my case is the first record show in first page in
format A. but, for coming 2nd, 3rd... records, they put in
a page with another format B which is different from
format A.

any help?
 
Brian

I guess I'm still having trouble understanding. ?Your report has multiple
"page formats", and some of the data is/could be repeated across multiple
"pages"?

Perhaps if you described more about those multiple formats... As I recall,
your original post only mentioned a single list of info.
 
Back
Top