Iif[ticket]=[ticket] & *, ticket, comment
I am trying to put code into the groupby of a report I am creating. right
now it is grouping by comment. However when the ticket it number is similiar
meaning if for example 1234 and 1234*. The * is the only situation I am

I have a report that has information coming in with dates by day. eg February
28, 2007.  I am trying to sort in descending order and cannot seem to make it
happen.  If I sort =month([date by day]) it does the months descending but
not the days.  Thanks

I have a query that is drawing information from two tables,
MailingList and Donations.  Within the Donations table, there are two
fields that are list boxes that get their information from a table
named DonationTypes.  Donations.Field1 lets the user pick from 6

I'm using this e-mail below to do exactly the same.  I want a page header to
start on page 2.  But I can't figure out where to set the property "Not with
Rept Hdr".
???

Any help would be greatly appreciated. Thanks in advance.

here is the simplified layout on my report
Line1TextBox1    Line1TextBox2
Line2TextBox2    Line2TextBox2
So, when Line1TextBox2  grows, How Can I make Line2TextBox1 and

I've asked many question on the group and many kind people gave me answer
now I would like to list them together. How can I do it?
Clara
thank you so much for your help

I looked through your forums and didn't see this question answered. Forgive
me if it is already there and I couldn't find it.
I have a report that I want to add a new text box to. When I create a form
there is no problem choosing the different control sources of data that I

I’m trying to make a text box return a “count” from another field that
contains a specific value.  I want the text box to give me a count of all the
records that contain “2320” but it gives me the count for all the values
instead.

Pardon me if this is a stupid question, but how do I put the Report's system
name in the report?  What I want to do is put the report name in the page
footer so that if there is an issue with a report, I can look at the footer
and the report's name would be there.  I know it ...

How can I get the max number of characters wihich a control can display in
the design mode?
Clara
thank you so much for your help

How can I decide the grow direction of a control: being vertical or being
horizontal?
Clara
thank you so much for your help

Are there two sets of function or one set function in Access. In Excel there
are two sets: worksheet and VBE
Clara

I am trying to calculate a total on a report footer but am having no luck.  
I want ot sum one of my fields from the detail section of the report that
uses values from a subreport.
Detail section of main report:

Please help - I'm doing something wrong but can't seem to get it!
Report totals expenses for projects.  Projects can have several expenses and
the budget is listed each time.  I only need the budget listed once.  Created
text box with Running sum for Budget named txtBudget, ...