We are setting up a database to recreate bank account information for
multiple accounts.  We want to be able to produce reports queried by our
choice of time period that show a beginning balance for that time period,
activity for that time period and the ending balance for that ...

Is it possible to preview a record by clicking on it in a subform?
I have a form: NonCompliance on which I have a subform to view all
NonCompliance records. At the moment I ‘m using a button to preview using the
ID number of the record to select the record to preview.

I know this may be a odd question considering the number of posts on filters
in reports... but I can't find anywhere a description on how to create a
filter (input box) in the report in the first place.
I have joined the source with a query that contains "total sales" for  each

If I have the query "UniqueCounts" and following query results:
Count               ServicesType
2                  Food Basket
99                 Men's Dorm

Hi, I am creating a report and experiencing problems with one text
field. I have added the source to the query behind the report, but the
report returns a null value instead of the value in the table. Can
anyone help?

I have a report that has 2 columns. My footer does not stay with the detailed
info it goes to the nest column or page. I want the footer to say with the
detailed info. I have tryed grouping together. Can anyone help?

I have a report with Group information.  I want to group by the Group number.
There can be multiple group numbers and I want each group number to have it's
own page.  I have the sorting and grouping set to group by GrpId. The Group
on is set to Each Value, the Keep Together is ...

Hi Folks - I have a report based on a query. If I need to pass different
criteria to the query, I usually build a form that collects the criteria,
then pass that form criteria to the query. However, once I do this, the
criteria form I built must be open for the query to run. To ...

I wanted to make specific text boxes stand out by changing the background
color based on a condition (ie. if person from one Company then yellow
otherwise Green). But have not been able to. I put this Sub in the Detail
portion...

I currently have a form where I have applied conditional formatting to
highlight a category yellow if the Field Value is Equal to "Report Due," is
there a way to apply conditional formatting if the field simply has the word
"Report" in it along with other text?

I want to be able to type in the month and get total hours for that month and
also get (as a seperate number) the total hours for the year including that
month (i.e if i type in june, i want to get a display that gives the hrs for
june, but also the hrs for jan,feb,mar,apr,may ...

How do I call up a specific report based on a field on a Form?
I have 5 reports, each designed somewhat similar, but paragraphs are
different on each.  I would like the form field "Contracttype" determine
which

Please help me to print a parameter to a report.
I have two queries Query_details and Query_sum.
Query_details gets the details and is a make table query(TBL_details).
Query_sum has a sum of the details form the make table query(TBL_details).

Well i think this is going to be a challenge...
My boss as intructed me, that she whant's de Report's form the data base to
display somewhat like the Outlook version. Explaining thing's:
She whant the day's apearing in a square, with the corresponding

In a report I am trying to develop a formula involving 3 fields; Young Adult
(text), Length of Contact (number) and Group Activity (check box).  I am
currently counting Length of Contact for the young adults using:
=Sum(IIf([Name of Child]="Mr. Smith",[Length of Contact],0))