I need to track bank statement data.  Statements must be grouped in the
following order: by customer, bank, account, statement date, statement data.  
I already have a customer table linked to the bank and account tables.  I'm
struggling with the best design for the statment table ...

I have import a table using ODBC and there is a field that is two alpha
characters which represents a name.  These two character fields could be "AB"
or "Ab" or "aB" or "ab" and all four are unique for four different names.  I
am trying to run a query which uses the two character ...

Sorry, i didn't know that i wasn't allowed to use attachments, this is my first time posting in a newsgroup, so i will try this again. First, here is the requirements:
CLIENTS    Name    Last name, first name, middle initial
    Address    Street, city, postal code
    Phone numbers    Home, work, ...

I need a code, expression, or a query that updates list box values based on
selected values in the combo box. For example, When choosing a country in the
combo box, the list box should list cities located in that selected country.

One table used check boxes, the other table used yes/no.
How can merge tables into one without loosing the data.
I don't mind changing the check boxes to yes/no or visa-versa, but it looks
like this will delete the data.

I am no programmer and I am a novice Access user at best.  My boss is
extremely cheap, however, so I have been tasked with designing a database
that will accomodate what Microsoft Outlook cannot.  
We are a granite countertop fabrication business and interact with

First, thanks for looking at this post.
I am trying to document the relationship (interpersonal / not neccesarily DB
relation) of 1400 people to each other. One table within the database
contains the data for each of these people in individual records.  

I'm have to recreate ~ 100 replicated tables to remove the
replication info fields ("s_..." fields).  Certain field
properties such as "Allow Zero Length" were reset to the
default NO when the new tables were made.  Is there a way

How do I get a drop down list to function in a parameter query. I want to
restrict queries to a select list with precise spellings to avoid
operator/user error.

Old versions of Access had a Database Documentor facility which was very
helpful but is no longer in the product.
Has anyone built this functionality into a set of VB modules that extract
the table, relationship, and column properties and put them into Access

Access would seem to be the perfect application for generating school reports
for pupils at the end of a term or year. However, I've never managed to get
to grips with Access. Anyone know of a good solution?

Which is used to produce more attractive output?

CREATE TABLE MYTAB(MYCOL DECIMAL(10,2) DEFAULT 10)
How can I extend this statement to include a Validation Rule?

How do I generate a report where I can have multiple listings under the same
header. (i.e multiple transaction dates (but only displaying the last date in
the report) and I want the transaction dates to be displayed corresponding to
only one company name.  I do not want a table ...

CREATE TABLE MYTAB(MYCOL DECIMAL(10,2) DEFAULT 10, Check([MyCol]>10)
With this SQL, the constraint is assigned a name. How can I recover the name
with SQL?
In order to find the name, enter an incorrect value in the column.