Query or User errors

Hi all,

I have a database designed to track subscribers to our paper, print
lists of subscribers for the carriers, print a pay request for our
accountant, track payments from our subscribers and I'm sure several
other things I have yet to realize. I'll try to briefly describe
them so that you can visualize the tables and relationships.

tbl_Fees: defines the type and price of our subscriptions; yearly, in
town, $48; yearly, mailed, $75; 6 month mailed...

tbl_Payment: tracks payments made by our subscribers; date, amount,
year made...

tbl_Carrier: carriers contracted to deliver residential and commercial
delivery; first and last name.

tbl_Area: areas of town we deliver along with how many homes and
subscribers are in this area; Las Alturas, 983, 16, commercial_1, 0,
189, Mail...

tbl_Complaint: complaints received from subscribers tracked by
subscriberID

tbl_Yes/No: a table which tracks all check boxes for a subscriber;
mailed, complimentary, commercial...

tbl_State: a lookup table for state abbreviations, it also enforces
integrity

tbl_SubscriberData: the monster; all subscriber data and notes so I
know whom I'm dealing with and their particulars.

The good news, with some test data (Old subscribers data) in the db,
all relationships work, are one to many and allow referential
integrity. My problem so far is queries. I seem to not know anything
about making them work. I've been reading "Using Access 2000"
and have ordered "Access 2000 developers handbook" but at the
moment, I'm stuck with F1 and a prayer as UA2K isn't helping and
A2KDH hasn't arrived.

The few I've tried return no entries and no error code so I'm sure
I've goofed somewhere.

Mainly, I'm trying to print my lists for the carriers and I'd like
to have several items on each report. 1) List of subscribers, 2) Do not
delivers, 3) Last week's complaints. These should be sorted so by
area as well so that as they are driving down a street, if they happen
to look at the list, it makes sense. Also if it is possible to order
them by preferred route, I'd like to know how to do it. In addition,
all Do not delivers should be printed red along with complaints and any
address that has been on the list less than two weeks should be
highlighted yellow.
Thanks for ANY help you can provide and I'd be just as happy to look
at other resources if any are available. TIA,

Byron

.

Relevant Pages

  • Re: An interesting note - definitely off topic
    ... exagerating and publicizing the claim, ... subscribers aren't subjected to advertising. ... entirely familiar with how mailing lists work. ... I put the list on temporary moderation. ...
    (soc.genealogy.medieval)
  • Re: Google Group scistatmath
    ... I learned a couple of days ago that Google-groups makes ... available the number of its subscribers, ... During the same period, the scistatmath ... My Usenet provider lists ...
    (sci.stat.math)
  • RE: Query or User errors
    ... There's only one practical way for us to know: Show us the SQL. ... query in design view. ... I have a database designed to track subscribers to our paper, ... I'm trying to print my lists for the carriers and I'd like ...
    (microsoft.public.access.queries)
  • Re: spammers harvesting emaill address from this list
    ... This does, in fact, open up a distinct possibility for list subscribers ... operating one or how that workload might be increased if some people post ... So rather than look for multiple methods to reduce the amount of incoming to ... lists. ...
    (freebsd-questions)
  • Re: Strange dream
    ... was sitting on the bed his face looking at the ceiling. ... Does Rolling Stone really try to make the best lists possible? ... subscribers, but our reporters have little say in what bands they are ...
    (rec.music.beatles)