Hi. I am having trouble creating a query that will bring back the results I
want.
I've set up a table that contains:
DuesRateID, EffectiveDate, and MemberCategoryID

I have a make table query I have set up.  It ran perfectly yesterday but upon
coming in today it was giving me a Unknown Jet Error.  When I clicked help it
brought up "There was a type mismatch when creating a table validation rule
or a CHECK constraint on a column. (Error 3072)."

I have a parameter query and I would like the dialog box that comes to be a
combo box to show me the possible choices to enter into the field for a
search.  Is their a property setting to do that or do I have to set up a
macro?

I have created a simple database for our church cemetery, one table tracks
the plots and their useage (ie: someone interred, reserved or vacant); one
table showing those people who are interred in which plot (can have multiple
people in plot depending or burial process); and a ...

Hello all. I have several queries that i need to add the uniqueID field to so
that they can be shown in reports already setup.
When i setup the queries i did not think i would need the uniqueID field so
it was not added when the query was first constructed.

Hi, I'm hoping someone out there knows the answer to this one!
I've currently got two tables that I'm trying to join.  However the
two fields that should be joined contain slightly different
information, i.e.:

Hey i have a table which contains new orders information includes date,
model, quantity, cost , total cost. I need some way of calculating and
displaying the total quantities for the different models in my form. im
really stomped

Have a simple question.........
select * from mytable inner join myaccounts on mytable.id =
myaccounts.sub_id where mytable.party = 'shripal dalal' and on_acc_of
= 'inv/1/07'

I have having trouble with this query, and am not sure how to go about it.
In my table that's linked to another shipping database, I have a main order
which is 221001.  At one point, Shirt, Pants, and Shoes were all under this
order.  Pants and Shoes were moved to another order ...

I have a query which contains a "Curr_Amount" column that has numbers, a
“Prev_Amount " column that has numbers and also a"Difference" column that is
blank. If the “Curr_Amount” increases or decreases from the “Prev_Amount”  by
10% ONLY... I need to note it in the blank ...

Can someone offer help on a database problem I'm having.
The situation: Training database with associates table, completed training
table, certificates earned table.
What I am wanting to do is use the database to run a report that shows which

Alright, I have eight fields in a record, all numbers. I need to build an
expression that will determine which one of these fields contains the
greatest value, then output one of 8 text strings to identify which field
contains the highest value.

Sorry for the subject description, I hope I can better explain my question
here.
I have a access 2003 database with related tables.  What I am trying to do
is query for records that do not contain a record type in a related table.

I have the following query Regarding Microsoft Access Db.
   We r using Access Db for an Web Application .....
   The application  contains the different modules containing Date
fields

My Switch is getting too complex - 14+ cases - and I have a couple
more cases to enter.
But it explodes if I try to add more.  I can't use a lookup table
because my expressions don't lend to that - because they depend on