Report with information from 2 queries
Fri, 26 Sep 2008 11:08:01 -0700
Is it possible to generate a report from controls from 2 separate queries.
I have a query which shows the sum of grants year-to-date and another query
showing event attendance to date. Id like to prepare report showing a
combination of the two queries. ...
|
Sum of Time
Fri, 26 Sep 2008 10:58:26 -0700
I created a report which shows time lapsed between an order entered and the
order worked on. I used a query to minus one from the other and I get the
correct time, which shows on the report.
However, when I use =AVG([Time Waiting]) in the footer of the report to get
the average of [Time Waiting], it shows ...
|
split field in report, leave together in field
Fri, 26 Sep 2008 17:43:51 GMT
I have a contact database, from which I print a booklet for my customers.
However, I ran into a problem where one field (Children) sometimes gets to
long and the field grows. This results in the adjacent field in the report
to skip a line. What I'm wondering is if there is a way to split the data in
a field so ...
|
How can I get a report in Access using record displayed in a form
Fri, 26 Sep 2008 09:17:02 -0700
I already have a report that shows all the records in my db; but, what about
if I need to show and print a particular record using the same form that I am
using to open and print the report for all the records?
--
Max Ortega ...
|
Report column titles taking up too much space
Fri, 26 Sep 2008 08:02:16 -0700
Is there a way to get the label text to wrap? In Excel you can do an ALT +
enter and put the column title on two lines. ...
|
Report re-print
Fri, 26 Sep 2008 14:36:32 GMT
I have a db that I use for tracking information, It has just few forms and 1
report.
After a recorded is entered and saved, I open a report of just that record
and email it,
which works fine. When I try to reprint a existing record/report using this
simple query
SELECT [Booking Notice].*, [Booking Notice].[B ...
|
Alternating Printer trays In Access Reports
Fri, 26 Sep 2008 07:22:00 -0700
I have a report that needs to print a 2 pages each for a mass mailing. These
are similar to invoices for customers and there are close to 20,000 records.
We will be using a Xerox docutech printer so the amount of records is not an
issue.
However page 1 and page 2 (of the invoice for each customer) needs to ...
|
|
|
Barcode Scanning
Fri, 26 Sep 2008 07:18:07 -0700
I have a barcode font that needs "*" in front and behind the data to work.
If I have a report that has a Name and control source of "PN", how can I add
these easy?
Thanks, Aaron ...
|
Seeking the associated printer
Fri, 26 Sep 2008 01:46:01 -0700
Access seems to be looking for the associated printer for a report. This is
fine when at work, but it can take 5+ minutes just to rename a report whilst
at home.
Is there a way to disable this 'I must find the printer' behaviour?
Thanks. ...
|
report with two one-to-many relationships
Fri, 26 Sep 2008 07:17:38 +0200
Hello,
I have three tables: persons, telephone_numbers and email_addresses. They
are connected one-to-many:
- one person has many telephone numbers,
- one person has many email addresses.
I want to create report, which will show persons and for each person will
show his telephone numbers and email addresse ...
|
