I need help with my design and relationships. I have the following
tables:
tblMember
MemberID

I am trying to fill in values of a table that already has data in it. I want
to assign a tracking number to a field which has some blanks. I want the
number to be CTW 1, CTW 2 and so on. How do i do this?
Thanks in advance

I keep getting an error message '#error' showing in my text box in the print
view of my report. The expression used in the box is =[dd/mm/yyyy]![Date].
Can anyone tell me why I'm getting the error message instead of the date I
specify when prompted to?

I know how to pick from a lookup table to insert information into a column.  
Based on the selection in the first column, I would like to have different
lists available for a second column.  For example, column A would have a
lookup table with "flow switch" and "level switch" as ...

Allow me to describe how I would like to set the number of decimal
places displayed in a report.  Here is it:
* values in tables are stored to three decimal places
* report prints out to two decimal places

Can you please help me!
I need to create a table(x) that is based on information from another
table(Y).  If the information in Y is updated/changed the information in X is
automaitaclly updated/changed.  

Further to the masses of headaches I am currently having is a problem with
working with queries in my access development. When I right click on a query
in Pivot chart view I get no options. When I try to change the view of my
open query through the view button i get no options. ...

When I originally created a report using the report wizard, I choose the
layout orientation as landscape.  Is there any way of changing it to
portrait?
Thanks

I'm having problems aligning text in my text boxes in my reports. I have
gone into "properties", "All", "Text align", then I have this set to "left".
The problem is that the text is aligned centered vertically. This looks bad
because when viewing the actual report, the value ...

I need to create a tracking system for my department which has 5-7 users.
I would like to know if access has the facility for multi editing (editing
by different users at the same time on the same table but inputing or
updating different records). Also can I have a front-end like ...

Does Access have a problem using an autonumber for a PK?  I've got 3 tables.
tbl-Parts
pk-PartsID - Autonumber
PartNumber - Number

I am trying to set a online tracking system for inventory as well as package
tracking.

In my table I have a field named Short_Description and in this field
contains various part numbers...example...6312-2RS(D), 1630-DCG(C),
SSR-10-DD(NX)...
I need to remove the characters in the paranthesis including the

  i am not able to design tables in an efficient way. Can any one help me
regarding table creation...Frist i wll explain the data to be stored.
An automobile company manufactures gaskets. for each gasket they wil assign a
part number. For each part thre could be multiple locations ...

I am using a field from a form as the criteria for a query. The field in the
form is a text field. It contains transaction numbers that can be a total of
10 character or less. This field contains values like 12345-0, 1234567-0 and
C  12345-0. When I execute the query there are no ...