I work for a church. We have committees that need mailings sent out. Some of
the committees have married couples as members, some have just the husband or
just the wife, some committee members are single people. When I run a query I
can get all the members but it will print ...

Ok, so I created this summary report by month but when I run the report it is
being sorted by month in ascending form. How do I get this to sort by
calander month?

I am doing a report and need the output of a text field to print an
ampersand.  Since this character is used to join text fields, how can I get
an output that includes an ampersand (e.g. output for field would be Bill &
Joan)?  Is there something to put in front of it or ...

I have built a report based on a query that is sorted by a case number.  
There is also a date field.  I'd like to get the report to group the cases by
year.  The closest I've come is to get a header for each record that lists
the year by using the following code:

I am trying to write a function in a report where it will count the number of records where a one field is equal to a particular value. The report is based on a query with parameters and the field in the report is a lookup field on the table the query is generated from. Here is ...

I have a problem that is probably due to a poorly designed set of
tables, but now I have a rather large set of data in the database that
I do not wish to disturb. This is a typical customer-purchase database
similar to the one in Northwind. The snarl comes in the way shipping is

I hope I'm posting this question in the right area.
I've created a report from a query that shows the number of jobs per person
within a date range. My boss wants me to add a field next to this "count"
that will calculate 1/2 day equivilents. The jobs are in increments of .50,

USing Access 2000. L:ogical field in table named "TrxRegistered" Use dteh
report wizard to create a summary report showing number of participants for a
series of sessions.
Thanks to D Hookum for his post earlier about the immediate IF to sum the

Is it possible to implement word wrap in any field in an Access database
report?

this is what i have:
myText (unbound) Control Source: =Sum(DateDiff("d",[StartDate],[EndDate]))
myCheckBox (unbound) Control Source: Show days?
when the report loads, you are asked "show days?", when you enter 1, the box

I have the following code in my report:
DoCmd.SendObject acSendReport, "CEM_Report", acFormatSNP,
But, in my mail, the attached file is not CEM_Report.snp but a file
like ' - CDB65.xls'

Can someone help me, my reports are not printing the data from the forms,
when I print preview them they are all blank, before they were all showing up
on the reports, now they arn't, please respond, this is URGENT! Thanks alot!

I am using the reports module to create an invoice. I want the report to
generate a unique invoice number. Can this be accoumplished using an unbound
text box, or is it safer to bind the text box to a table?
The flow of transactions will be:

In excel, numbers can be easily converted to ANSI characters using the
CHAR(#) function.  Is there an equivalent function in access, or some means
of producing the same result?
Thanks.

I have a control on a form with the following formula
=DSum("[FeeAccrued1]","qry_RCTrack"," [sCliNum]  = ????")
Obviously the ???? is the part I can't figure out.  I'm trying to sum the
FeeAccrued1 field where the [sCliNum] field from the domain equals the