adding text to appear after data, and sorting on two fields combin

[Guest]

I've worked with Access for a while but never used Reports (always used it as
a database for a program or for a web site). I have a couple of questions.

Our database is relatively simple. A list of donors for an organization.
First name, last name, address, etc, plus how much they donated and if they
received a thank you card. We're simply trying to print them out the way
we'd like and I'm not sure how to do a couple of things.

First, if I want to print out "City, State"
How do I get the comma to appear right after the city name each time. I've
used a label box but that always puts the comma at the end of the max lenth
of the city field and not right after the data. And to continue with that,
we'd then want the State to be one space away from the comma, again, how?

Second, We have a list of people but also businesses. We have separate
fields for these in our table, but we'd like to be able to sort these on both
of these fields. For example, if we have the following data:

Joe Smith
Mike Adams
Betty Adams

and also these bussiness

AAA Plumbing
LZR Produce
Z-tron Computing

We would like it to be sorted like such:

AAA Plumbing
Betty Adams
Mike Adams
LZR Produce
Joe Smith
Z-tron Computing

Is that possible?
If I have to go into the scripting part of the report, I'm relatively
comfortable doing that (I used to do VBscripting on webpages) but never
getting into the VBA in Access I'm at a bit of a loss on where to begin and I
don't know if that's even neccessary.

Thanks for any assistance that you can provide.

 

[Guest]

Sorry, forgot to mention, we are using Access 2000.

 

[Duane Hookom]

Use a text box with a control source of:
=[CityField] & ", " & [StateField]
Make sure the name of the text box is not a field name.

You can use IIf()s or Nz()s with & or + to arrive at the results you want
for sorting. We haven't seen your table structure so please check Help on
these functions etc and come back if you have troubles.