I currently have created a project and all is going well. I have
written a access program to retrieve data from a DDMS System (Supplier
program). The company has asked for several enhancements and I have
been able to handle them. There is over 250,000 records and the DDMS

I have a rental database - There are three primary tables.  Properties,
Leases and Tenants. The Leases table has two date fields - Arrive and Depart
-There are multiple properties that may be leased.   I need to be able to
identify which dates are available for lease and which ...

I have a database table with one of the fields being postcode. Access
originally sets this up as the US Postal Code  I can change it to the UK
Postcode Format However since in the UK The following formats are used viz.
LL0 0LL OR L00 0LL I find it impossible to get both of these to ...

Sorry for the duplicate subject, my hand slipped!!!
I have two databases.  
Database A - I did a make table query (as the table did not show up when I
selected File - Get External Data and selected the database).  

Thus far, I have a number of tables to track a Projects/Studies with a tables
for Investigators, Studies and a joining table ensuring a M:M relationship.  
I am having difficulty with what I believe should be a simple 1:M table for a
comment table.  The Comment table should link ...

I currently have a events database that stores details of courses and their
attendees.  I would like to add an attendance part to this datbase so I can
see when people attended (or not).
The tables I have so far are

Access Help
My job: I have a task to organize drawings and keep out duplicates.
Problem: I am working with drawings that have multiple tracking numbers that
have repetitive information among the tracking numbers. These tracking

I am trying to have a seq# starting at 64 then increaseing by one each time I
add a new record is there a way to do this?

if a table with two columns column A represents Column B (two different codes
same item) i can't get away from that but on my form i need to be able to
select either and show the other as well so TextBox A i want to show Column A
and Textbox B i want to show Column B  i use a ...

Trying to build a database to track Project Costs and Billing.  Having
trouble with billing aspect.  Would appreciate help.
Each project has several project-specific "Activities", in turn each
"Activity" has several typical tasks... eg. "Drafting", "Engineering",

I have set up my database completely before I started looking into archiving.
I have many forms and reports, which I only want to display current records.
Do I need to append every table with a date field in order to filter all of
my queries to only show current and not ...

I dont know if I have phrased this correctly but there must be a more elegant
solution than I am using now.
I have a database for managing education courses, I have tables for
Attendees

I have to construct a database to record survey results. The questions are
wordy, but the answers are primarily yes/no or numeric.
My challeng is to set up the tables efficiently. My initial thought was to
create tables that would use a crammed-in version of the question as the

I have a Parts table, a Purchase Orders table, and a Purchase Requisitions
Table.
These are all many to many relationships and we will need to pull data from
all tables, such as PR's and Parts data, PR's and PO's data, PO's and Parts.

Although Part Numbers are unique, is it better to use auto numbering (such as
id_PN) as the primary key in a table? What are the pro's and con's?