I have 2 queries that I want to bring in to one report.  The fist query
contains MTD data and the second query contains YTD data.  I want the MTD
data at the top of the report and the YTD data at the bottom of the report.  
How can I do this?

Whats the maximum number - I know 370 is too many

I want to count all records in a table from a calculation on a report. When I
use the dcount function it doesn't count the duplicates. How can I get a
count of all records.

I'm trying to figure out how to have the tables or queries related so that I
can use them all in a report.  I can't join the queries because this will
make the query to complex and I can fit all the information in one query or
table.

I was recently asked to consolidate several tables
prepared by others in one database. I imported the tables
with no problem however one particular table had all the
data in one of the text fields (i.e. Field - Name of City)

I have a report which lists the employees by day
2/21   10 (bold)
2/22   12(bold)
2/23   15(bold)

I did a search and found several solutions provided for this common question.
However, I noted that all of them require me to place codes in each of the
fields and it gets a little tedious when I have 15-20 fields or more.
Is there some code I can apply globally to the report to ...

I am attempting to create a report that can sort through
the data on a table.  This table and report will have
numerous columns, but the only ones I am struggling with
are as follows: [traderate], [daylow], and [dayhigh].

Is it possible to make bold the word "Notes" in the following code?;
="Notes: "&[notes]
I've looked into the format() function but I'm not finding anything
regarding text formatting.

Access 2000
I have a report that I created using the record number
(auto) as the first sort field. Now as I continue to add
new records I would like to not show the number field (no

I have a date field with dates in the format 9/23/2004.  
Now, I have a requirement to summarize my data by month.  
How can I do that?  I need to find out how I can use the
Month function to group my data by month.

I have a rather complex report that includes 2 subreports.  In the report
footer I have a textbox named txtGrandTotal, which I initialize to 0 in the
ReportHeader_Print event and increment in the DetailFooter_Print event with
the formula txtGrandTotal = txtLaborSubTotal + ...

I am wanting to create a report using individual dates as my Row header.  
Currently I can only show those dates which I have data relevant to, I would
like to show on my report all dates within the range selected.
Thanks for the help

I have a database that's used to submit Maintenance work
orders. I have a form that people once completed clicks a
button that generates a report for our Maintenance
department.

I have a date field in the format 01-jan-04 and would like to report on data
to show by week, ie Week 1, Week 2 etc.  I need to find out how to group my
data using a by week function.  Thanks for any help you can give.
Pete