Hello: A design subject:
I have two tables that define a similar data set and another different data
set.
Table: CableCopper (id, code, type...., Caliber, Pairs)

Is there any way to format a number field as percent so
that you do not have to enter the number as .03 to obtain
a value of 3%.  I want to type in just the number 3 and
have it appear as 3%

i am using access and i want to rank my table by group of product
tblProd                 and i want
a,...                        a,1
b,...                        b,1

How would one make a expression that can perform two
different addition operations to fill a field depending
on the value of a number found in an earlier string? For
instance, if the number is between 1 and 3 add 10, and if

I need to know the advantage and disadvantage of split databases especially
in multi-user updating, database sharing on file server and data corruption
and aspects.  Your advice is appreciated.
Thank,

Table1 has two fields that I want to link to the primary
field in Table2. My goal is to create a query that lists
data from different rows in Table2 for every row in
Table1. For example, if Table1 has a StartDate field and

Hi Guys, can anyone help?
Is there an access equivalent to SQL's truncate table
command? I need to very quickly delete all records from a
table but keep the structure of the table. Running a

I have a database that is shared by multi users.  Is
there any way that I can format the inputting of data so
that it is uniformed i.e. All words start with an UPPER
CASE and then subsequent characters are lower case.

I have a table of past jobs my company has worked on. A
feidl in this table is "client name". I have a
switchboard setup with some reports on it. One of the
reports is pulling all jobs by a paticular client. I want

In the table, I set the field required to "Yes". If it
leaves blank, the standard system error message popup. How
could I replace the system error message with my error
message? I tried to put it in the validation text, but it

I need some help with designing a database to keep track
of information.  I would be willing to send a copy of it
in order to get a better understanding of what I'd be
using it for.  I have the fields done, but I need to

I know how to protect my complete database with a
password, but, is there any way I can put a password just
to open one of my tables?
Thanks for your help

I need to know if there is anyway to creat some kind of
local veiw/table, that flattens out data that has been
normalized accross 4 tables, that I could then call from
another query.

    I'll try to phrase this question correctly. I need to Have a link to a
table that contains store numbers and addresses. I want this table to be able
to be populated by adding data from the first table containing the foreign
key. Whenever I setup a link, it operates as ...

I have three tables, one for customers,one for invoices,
and one for adjustment codes.The customers table works
well for the one to many(cus)to (inv)tables but the
adjustment codes will not let me have referential