I have an Access 2000 database. I wrote an append query to append from one
table to another. The fields are all the same. The only key on the table
that I'm trying to add data to is an AutoNumber field. I am NOT trying to
append data to this field.

I need to search fields in the database that contain certain a given string
ie if the user enter ABC and the field content is 'ABCD' the record should
then return
Thank you,

It's my first time to build a database and  just learning Access as I
go . I am trying to design a simple database on survey tracking. Here
is my table structure:
tblPerson

Is it possible to create a crosstab query or pivot table that summarizes the
data without the calculations? I have a table that lists courses that are
taught (including which semester and which period of the day) and a table
that lists the instructors. I need to combine the two ...

Dear friends,
I have a table tbl_Members and every year I will sent subscription invoices
to those members, once a year.  I need to run (I don’t know – perhaps a
query) in order to append into the table tbl_MembersSubscriptions for each

I have a question about nested join.(I'm not sure that this is the right
name of this join)
I want to create the following querie.
I will give an example.

I have a query I am trying to design for a manpower database I am working
with. I have two tables among others involved in the query. The first table
is called Shifts and displays all of the available shifts and jobs. Each
record in the table has  two fields: shift code (ie ...

Have 2 tables:
INVOICE DATA: consisting of Invoice Number (key, autonumber generation),
customer number, sales order number, amount, sales order date, invoice date,
status, comments

I have MDB, and I have form for every table.
The MDB is for CRM.
I want to know how to write syntax to make search in some field.
I mean that, if I have Customer form, that his details are:

Any help will be appreciated!!!
1) What I have:
- 14 tables in Access 2003 with randomly missing records in every table;
- all 14 tables have the same primary key (Column 1) and have a one-to-one

i have a table like this:
Name   Category    Team   Speciality
Ken      A      K1     100m
Ken1   A       K1     100m

I started this discussion in another thread, but have solved my initial
problem so I thought it warranted a new one.
Here is my expression
FirstName: Trim([dbo_Pr_EmpDemo_T]![chrFirstName]) &

Why is this not possible?  I have a Date field that is sometimes null,
but I still want to be able to pass this value to my function.  I get
the data mismatch error though...
It makes no difference if i check for IsNull inside my function as it

Hello all, i've got an empty table with it's own set of headers. i've got a
second table full of products also with it's own set of headers. they are
totally unrelated. i need to get the data from the second table into the
first table so that i can upload it to my store and populate ...

How can you print out or copy the the database design to a file?  Field
names and other information?
Anyone know?
Dale