What I have is:
             FldA    FldB    FldC   FldD    FldE    FldF
cust1         1         1        1        1        1       6
cust2         1         2        1        1        1       1

I hope this request is not difficult but I have a form with a Loan Amount
field. What I am trying to do is, create a report that will show the total
Loan Amount for the chosen date range. Example: Currently, if I pull a report
for May, I have 52 pages and at the end of the report ...

I have a report built on a cross tab query.  I'm tracking exceptions
by employee weekly.  So at the end of the week an employee has a total
number of exceptions.  My crosstab returns employees and total
exceptions by week.  How can I setup the report so that the text boxes

I have a calculated control on group footer called txtFlex
=IIf([semester]="Fall Full-Time",[FT_Fall],IIf([semester]="Spring
Full-Time",[FT_Spring],Sum([Hour]/2)))
I want to total it in report footer

Excellent program....I do have a question though.  Is it possible to prompt
the user for the output location?
Thanks
JG

I have a query that returns a result set like this:
Rec ID 1: Ledger = FY07   Amt = $300.
Rec ID 1: Ledger = FY06   Amt = $200.
Rec ID 1: Ledger = FY05   Amt = $100.

I need to create a report where the user will enter a date on a form. Then on
the report it will start with the month that they entered and follow through
for the rest of the months. So if they enter in 06/01/07-06/19/07 the data
will show as follows:

Access 2007 - I am using an attachment field to link to a photos.  I have
tried jpg, png and tif format.  All are good quality in the Report View and
Layout View, but in Print Preview they have jagged red streaks through the
photo and print with those streaks on most printers.  i ...

I'm trying to use a database to generate ID badges 2' x 3'.  Having
difficultly gettting the page size to work where I will get one record per
page to print at this size.  Also would like to get text to print on the back
of the ID badge so this would require a page break between ...

Hi, need urgent help on the following topic:
I'm currently using the following code to create a report. How do I add the
current date at the end of the file name for every report created? So I can
distinguis them and to prevent overwriting them?

On a report I have a date field for when the employee was hired. When I have
just the date in the control source box it displays fine. I would like to
concatenate this date with the word "Hired: " and have it show up in Long
Date format. Now I know I can use two text boxes, one ...

Wonder if someone can advise.
I'd like to take a single field from a query and have all the results
printed continuously, each field separated by ; and nothing else (i.e. no
spaces).

I have two tables imported to Access.  Both have same column headings.  
GLNO|SERVCD|DESC|MTDIPQTY|MTDIPAMT|MTDOPQTY|MTDOPAMT|YTDIPQTY|YTDIPAMT|YTDOPQTY|YTDOPAMT
Each table is named by the date and time it was run :
Table 1  061807-1214p

I need serious help.  I have been trying to make this report filter for what
seems like forever.
I have a huge query, since I couldn't figure out how to filter both a form
and subform and read it wasn't a great way to go.  The query is all the

I have a query that asks for a "begining date" and "end date" as
parameters.  Is there anyway to poulate these two dates on a report
so
that the user knows the time frame (they just keyed) of the report?