I have a report based on a query that lists cost code
expenditures by month.  I cannot get the months to come
up in order.  They appear in alphabetical order, not date
order.

can I have microsoft power point free

I have several reports based upon the same query that present data in
different ways. For example, Detail for past month, Summary for past year,
Summary by salesman for past quarter, etc.
Currently my query selects the date as "Between [StartDate] and [EndDate]"

I am trying to create a letter as a report but I need to add part of a query
into the letter.  Is that possible?  I have created a query with all the
departments, with the employees names and I would like to add the names to
the end of the letter.

The user has a routine Access report that the he wishes to export and save
each day as an Excel spreadsheet.  Today, the report export line count
exceeds the allowable import line count for Excel.  None of the three
workarounds described elsewere on this site will work.

I have followed the support.mdb suggestion to create a report with Dynamic
Headings.  I created unbound fields called Head1 - Head 22, Col1 -Col22 and
Tot1 - Tot22 When I try to run the report it comes up blank.  I believe the
code is wrong.  I am sure with the right code it will ...

Conerning the report paramenter box,  I would like to insert a drop down menu
to choose a value rather than type one in. Example: Instead of entering a
customer number have a drop down menu to select a customer from. How can this
be acconplished?

On a Totals query for a report, I want the user to be able to check an
option box on a Dialog form and have an Average, or Sum returned by the
query.
The form is frmDialog, and the Option Frame on that form is [AverageOrSum]

I am using Access 2000. I have a sales table that contains fields for
invoice date and invoice amount. I want to create a report that shows sales
totals for a three year period. I'd this report to be in a grid format that
not only shows the three year total, but also shows the ...

I have a sub report with a "count" in the report footer. When I run the sub
report it works fine. When I insert the sub report into my master report the
value on the sub report is always "1". How can I fix it?

How can i create text boxes in a report automatically?
It depends from how many statistics user wants to view!
Sometimes user wants 5 text box and other more, 7 or 8...
I can change properties and display text box where i want or with sources

I asked a question about getting data from 2 different querries onto one
page and got following suggestion:
half page pulls the data from one query, and the rest
of the page pulls data from another query. If so, place

I am using ms access 2003 and building one application
that contains one form and a report.
In form, I have two fields name and address and one
submit button that display report..

Hello Ladies and Gents, I'm making a database to track members at a fitness
club, this is what I have as the control source for it:
=DCount("[memtype]","Members","[PayMeth]=5 OR [PayMeth]=6 OR [PayMeth]=7 OR
[PayMeth]=8 AND [memtype] = 1")

i am trying to create a report that, using a start and end date that is given
on a form, groups by part number and sums the number of parts sorted per part
for the given date range.  this part works fine as the date, part number, and
the values for the total sorted are all in one ...