Any way to export a Report, its' calculated fields and format to Excel
instead of just the data fields?

I have a Timesheet application for figuring payroll. I need to calculate
overtime hours on a report. I have a Query that returns all the information
except the calculated information.
SQL for Query is:

I'm trying to convert an SQL statement to VBA to use as a recordsource
for a report. I've got most of it done, but the following section is
giving me fits.... How the hell do I do this?
SELECT tblResourcesFirstName & " " & TblResourcesLastName AS FullName,

Each month, after our statements are imported into our database, our
accountants run a report on our conference calls. Before they run the report
I must remember to change the query to reflect the month being searched.
Is there a way to create a report that will give the ...

I have a subreport based on the following query:
SELECT CallType, Count(*) AS NumOf
FROM qryOne
GROUP BY [CallType];

Hi.. i design a report via vba like this:
1) open the report in design mode
2) design
3) open the report in preview mode

I have an access 2003 database linked to a sql database records system to do
ad-hoc reporting. My problem began when the company upgraded us to a new
version.
When i run a report in access they have a narrative field that is rich text

How can I list the table name in a report footer? I understand text boxes and
footers, but is there a clever way to get the table name into the control
source?

I have a report that prints dates (they come in from a table column which is
date/time). In certain circumstances, when the dates are blank, the user
wants me to print "TBD". I have tried various ways to achieve this to no
avail , nothing seems to work. Any help appreciated. This ...

I fugured out how to export a query to an Excel spreadsheet, but that code:
docmd.OutputTo Seems to take the output and make it the entire workbook
results.  How do I take the query and make it export to the 'TargetFile'
workSheet("Data") beginning Cells(10,1)?

I created a crosstab query to analyze sales data. It takes about 15 minutes
to run the query and several large tables are linked.  When I tried to save
this query as a report, it took hours for it to generate the report format.
When I tried to select Design view to modify it, an ...

I did quite a bit of searching and see many topics on this, but I am still
confused and cannot get this to work.  Particularly with the link everyone
provides: http://www.mvps.org/access/reports/rpt0013.htm
I am not sure how to do a few things...

I have a report in access that fills in report information from a query. This
report may go to 1 customer or may go to 20, and I've set up the report so it
will create a new page for each customer.
I would like some way to be able to enable the user to fax this report to

One of our customers has multiple people using an access 2000 MDE that is
using the docmd.sendobject method to send an email of a landscape report to
an excel spreedsheet.  The problem we are having is when people using pc's
with screen resolutions of  800 x 600 instead of ...

Hi, there!  I'm trying to figure out how to have one of my fields display a
record conditionally.
If [MemberCategory] is "Add'l Pay" or "Family Pay", I want [MemberCategory]
to show a blank, otherwise list appropriate [MemberCategory].