I recieved a database with hundreds of blank records. Is there any code that
will delete the blank rows. Deleting them manually will take quite a long
time.
-Sky

I have some reports which are based on a date criteria that is entered in a
message box. I want the entered dates to be capture  unto the report that
comes up based on the date.
Can someone help please.

I have a report that has a very complicated calculation. The calculation is
not contained in the underlying query. Does anybody know how to filter a
report based on a calculation contained in the report?

I am using Access 2000 at work and have developed a report that I would like
to filter out the duplicate entries, without deleting the duplicate records
in the underlying table.

Hi,
I have a form that has a few unbound text boxes that are used to enter
information such as Purchase Order number, quantities and descriptions.  My
question is, when I am done entering the data into the form and I save it as

=IIf(IsNull([SumOfPD_HRS])," " &
([Label19].[Visible]=True),diff2dates("hn",0,[SumOfPD_HRS]))
May I know how come the above syntax keep display "0" when IsNull is true.  
I hope to make label19 visible if IsNull is true.  Label19 is set to visible

I used the textbox-running sum method to print a line number for eac rec in
the detail section, but the number does not go beyond 99...any
suggestion/solution? Thanks!

I'm using info from two tables to print rolodex cards, which are a fixed
height and fixed number per page.  My report contains data from two tables:  
one table with family contact info (the header), and one table with people in
that family contact info (detail).

I would like to calculate the averages on a report but without including
null values. I have based my report on a query that eliminates null values
for one field but now I need to do it for another field on the same report.
Any help would be much aprreciated.

I need a quick help regarding MS Access reports.
Let me explain the scenario in my report with an example:
Total marks scored by students in a various level. I have ordered it
according to the level first. For the level I have a group header.

I have read some post that are related to the wherecondition but still can
get my problem solved. So here is my problem. I have a report that returns
all computers that have a given operating system. The user can select the OS
from a list box I can not get this to work. I keep ...

I have 4 fields of data that populate my report. The data
in one field is so long that it takes up practically the
whole width of the page. Is there any way of wrapping the
text automatically to a fixed column width size?  

I'm trying to create a text box on a report header based on the items
selected on the multi-select box with the values listed one behind the
other (i.e., 440203, 440209, etc.)  The multi-select box name is TempRCN.
The values are obtained from qryforMultiSelect.RCN.  Any suggestions ...

Can anyone help me with this?
I have a value field in my report. I want the value to be formatted with two
decimals and I want the field to show nothing or just '-' if the value in
the field is 0.

Hi, everyone,
I have prepare a subreport shows the details while the main report shows
other information of the record, pretty standard use for subreport.
However, as the report source is based on a query.  In case there is only