OK I have a simple Acc 2000 (or maybe not) select query based on 1 table.
There are 19 fields with 7 having Selection criteria on them something like
this "[Enter Table Name] or [Enter Table Name] is null".  I save it and it
works fine for a while sometimes up to a month.  Then all ...

I want to put the path details of the Access file from which a report was run
into the footer of a report. Is this possible and if so how?

I hope I can explain this...
I want to have, as a selection on a switchboard - run a certain report.  I
can figure that part out.  However, when people select this option, I want a
box (or something) to appear where they can set the criteria, based on 4

Hopefully someone can help!  I've been googling my brains out on this
and found little info.
I have a report, rather large, that I want to have staple after each
group.  I saw somewhere in my journeys that someone suggested writing

When attempting to create a report from a query, one of my record sources is
a combo box. When the report is generated, the field that should be populated
by the combo box text entry is filled by the primary key of the table used to
fill the combo-box.

I've tried to set the image height of an
image control in the OnOpen code:
Me.ctlImage.Height  = 1.193 * Me.ctlImage.Width
such that it will conform to the aspect

In a report, I have a total of a grouped field of four records, I would like
to sort these groups by the calculated field in the group footer while
keeping all four records in the group together.
How can I do this?

I've problem with printing color images set as the background to reports.
Report preview looks nice, but printed document is poor-colored :(
Anyone can help?

I have a database with many check boxes and pull down options for each record.
I need to be able to print only the boxes checked or filled in for a
particular record.  How do I tell the report or query to print only selected
(filled in) parts of the record?

I could not seem to find the format syntax.
I want to format a date field to display '------' when there is no date
to print in a record.
Can this be done?

I have a field in my table called Group and the groups are numeric values.  I
want the data on my report to display in assending numeric order but it comes
out like this 1, 10, 11, 12, 2, 23, 3,  4, 5, 6
how can I make it sort like

I have a report that uses conditional formatting to change the font color of
a label to white (which in effect makes it invisible) when certain conditions
are met.  This works just fine except that one computer has started to leave
the font color black when the report is ...

I have a report that has a subreport in the group footer.  I want to
highlight(either conditional format or onformat of detail section)
when data in the subreport matches info in the detail.  I have not
been able to figure out how to do this and do not want the opposite by

I have a report concerning adolescent patients, the patient may have 1 or 2
parents in the database.  I have a report that requires only one of the
parents to show up.
All of the details are to show up on one page, as this is a cover page for a

I am designing a one page report that consists of 2 subreports to display
the data from 2 tables. One of the fields in both tables is time/date, and
all the records have the same date but different times. I would like to
display the date from these fields in a text box in the ...