|
|
|
|
13 |
1,551 |
|
|
Text vs. number by
I was under the impression that a field should always be formatted as text
if the contents were not going to be used in calculations, so I formatted
fields...
|
|
4 |
289 |
|
|
data design question by
PF
Hi all,
I have a product table where each prod can have from 1 to 10 suppliers
What is the correct way to build those tables?
tblProd tblLink ...
|
|
1 |
225 |
|
|
|
|
1 |
322 |
|
|
Check constraints by
Aaron Abdis
Hello,
I have a table called Company_Locations. There is a field named Is_Main. For
any given COMPANYID, i want that only one Location can have the...
( 1 2)
|
August 14th, 2004 04:19 AM
by TC
|
11 |
249 |
|
|
|
|
1 |
289 |
|
|
Look up wizard by
L&P
We are trying to design a table that has a look up field.
We want it to look up from another tables look up field,
which is a list. Can we do this?
|
|
2 |
162 |
|
|
Sum total calculation by
Hello,
I would like to obtain a sum total on reports for billing
codes that identify patient charges.I have various codes
so i want to specify them by their...
|
|
3 |
161 |
|
|
100 YES/NO fields by
TonyTOCA
I want to design a table to store data on labtest aquisitions, to
print out labels later. It will be a list with 100 different tests,
every test with its own...
|
|
6 |
137 |
|
|
Table / query Design by
sam
Hi,
I'm wanting to set this up but am unsure of the best way to go about it. All
I have is basically a 'service' which will belong to particular areas...
|
|
7 |
217 |
|
|
|
August 13th, 2004 03:15 AM
by
|
3 |
187 |
|
|
|
|
2 |
719 |
|
|
Split Name field into 2 fields by
S Jackson
When I originally designed my table, I used one field for the Witness name,
called . Now, I would like to divide that field into two fields:
, . Is there a...
|
August 13th, 2004 02:07 AM
by Annelie
|
3 |
123 |
|
|
Formatting Autonumber by
Chris
I am trying to set up a field in a database i'm creating
to generate a specific format the same way Autonumber will
generate a 1 then a 2 and so on. I want my...
|
|
3 |
126 |
|
|
|
August 12th, 2004 07:17 PM
by Naveen
|
4 |
322 |
|
|
Automatic insertion of data by
pmp350
How do I have Access automaticaly insert info into one field after I have
entered info into another field. Example - I want to enter an "Employee Name"
in a...
|
|
3 |
189 |
|
|
Bug? by
Al
Does any one know if there is any bug in Access that makes
some of its tables lose their relationship to one another?
this happend to me couple of times...
|
|
1 |
119 |
|
|
|
|
0 |
112 |
|
|
Command button to open Excell on form by
joe
Hello,
On my form, i have tried the steps with the command button to open an excell
worksheet on event but the results are it opens a workbook and then i...
|
|
1 |
114 |
|
|
Need help w/ table design by
Tom
I have a question about table design (in conjunction w/ form design).
Although this question is focusing primarily on table design, I'd like to
start out...
|
August 12th, 2004 02:34 PM
by Tom
|
0 |
532 |