I currently have a report that gives me varies info about employees that
have seperated and the positions they held. I'm using this to track
seperation info per department. I have a form that I enter a date range to
get this info for peoples records that contain a Seperation Date ...

I have a lot of fields in a Db and need to be able to print each record with
about 60 fields out on one page.  Is there anyway I can use tab windows to be
able to view it all on one page or is there anotherway to have mutiple layers
to a report or am I just out of luck and going ...

FIXED!
RE reports don't open in access 2003 after converting from Access 97
Just to let you all know, changing the default printer to a different
printer allowed Reports to open (and be edited and created) again :)

System info: SQLServer backend, Access XP adp front end delivered to each PC
on boot.
I am using Leban's fLoadPicture code to counteract memory leak.  The report
is a student directory that loads each student's jpg picture or a "No Image

I have a report with 2 subrpt this is my formula on my 2ndsubrpt
=Reports!rptLotterysalesByStore!Text51-Reports!rptLotterysalesByStore![LotteryInventoryPaid
Grand Total Sum]+Reports!rptLotterysalesByStore![TerminalFee Grand Total

in accesss reports: for some reason my section header ( the header is a range
such as $200,000-$300,000, $300,000-$400,000,etc)repeates with each record
from the detail section. I just want it once, till the range changes.

I have a report to print instructors' roster with student name listing. I
groupped by instructor with force new page before so each instructor is on
his/her own page.
Report preview is fine, with each instructor on his/her own page without

I have a report bound to a query using Access 2003.  The report is exactly
3.5 inches by 7.5 inches and is intended to be used on a continuous supply of
checks printed on a OkiData 321.  
The report prints 2 checks then form feeds as if it was an 8.5 x 11" sheet

I'm using Access 2003.
My database has several fields set up as list boxes with a value list and
specified items.  I've done a query including these fields and set up a
report on the query.  When I print the report, the fields in question come up

after a little looking into what i am experiencing i would have to say its
wierd that i am the only one having this problem.
i have a main report which has a report header, page header,
"mysectionheader", detail, page footer and a report footer.

I'm trying to use an IIf statement to essentially say:
If the following field contains text, then make this field 1, otherwise
make this field  0
The expression I'm using is:

Is it possible to have the value right justified but the dollar sign left
justified in a report field?
-Adam

I have a very basic problem that I cannot seem to fix.
I want to open a form and display (only a few fields) the first record in
the table.  Then, after clicking the NEXT button, I want to dispaly (on
another form) only a few more fields in the same record (the first record in

I am trying to pull data from different fileds in a table, called Master
Table.  I want to create a report that would output this information in a
pragraph form like below...
The epsression I used is this:

I know the problem is with my Where clause but I am not sure how to fix
it. Here is the error.
Syntax error in date in query expression '([RCName]= 'Athletics' AND
[DeptName] Like '*' AND [Date Entered] Between ## and #9/22/06 >0)'.