|
|
Separate PK in Jxn Tbl? by
Neil
Whenever I've created junction tables in the past, I always made the PK of
the junction table the combined pks from the two other tables. Ex: Table1
PK=A;...
( 1 2 3 ... Last Page)
|
|
222 |
8,766 |
|
|
|
|
73 |
2,708 |
|
|
|
|
60 |
2,382 |
|
|
Autonumber Fields by
Denis
Access allows a table to have an autonumber field which could be considered a
record number.
In an application I am involved in developing there are a number...
( 1 2 3 ... Last Page)
|
September 29th, 2005 02:14 PM
by BruceM
|
59 |
2,364 |
|
|
How do you mulitply in a field? by
wazabbbi
I created a table with two fields named "projectestimate" and "inspectionfee".
The inspection fee is 5% of the project estimate. I want the "inspectionfee"...
( 1 2 3 ... Last Page)
|
|
56 |
2,277 |
|
|
Table/Forms Design Question by
Damian
I am Trying to create Daily Reports for my company.
I created tables for Carpenters, Laborers, Surveyors, Ironworkers etc.
Each of these has fields *_Name,...
( 1 2 3 ... Last Page)
|
July 29th, 2009 06:43 PM
by Damian
|
54 |
3,255 |
|
|
|
|
51 |
3,420 |
|
|
|
|
47 |
1,782 |
|
|
|
|
40 |
2,005 |
|
|
|
|
40 |
1,688 |
|
|
|
|
38 |
1,863 |
|
|
|
August 14th, 2006 09:06 PM
by Bob
|
37 |
1,772 |
|
|
Hostel Database Setup by
andreainpanama
Thanks to all of you for all of your help.
I have a small backpackers hostel and I am currently working on a database
to help me keep track of all of my...
( 1 2 3 ... Last Page)
|
|
36 |
1,615 |
|
|
invoice number by
cjgav
I would like to add an invoice number to report which is generated only when
the invoice is printed can anyone explain how to do this please
( 1 2 3 ... Last Page)
|
June 17th, 2009 10:01 PM
by cjgav
|
36 |
1,953 |
|
|
A2007 - OLE vs. Attachements by
Jay Oken
I would like to add a picture to a record but do not know the best way to do
it. From what I can see OLE gives the option to "link" to the picture file...
( 1 2 3 ... Last Page)
|
November 20th, 2009 10:28 PM
by johnlute
|
36 |
2,158 |
|
|
|
|
35 |
1,839 |
|
|
|
|
34 |
2,626 |
|
|
do I need more indexes? by
jmoore[_2_]
After reading several posts here I have changed all of the lookup fields to
text fields in my table and deleted the relationships to the lookup tables.
I...
( 1 2 3 ... Last Page)
|
|
33 |
2,071 |
|
|
Membership database updates by
Pennington
I have created a membership database for our local branch of a charity and
designed various queries and reports to analyze particular trends. The source...
( 1 2 3 ... Last Page)
|
|
33 |
1,867 |
|
|
Monthly Vendor Report by
DRoads
Need help and don't know where to start. Working in Access 2007 and need to
create the following.......
Need to create the following report
V# Vendor...
( 1 2 3 ... Last Page)
|
|
30 |
2,311 |