I'm modifying a table created by someone else. System is a library database,
with the need for multiple "subject" entries for each book. Current database
has a single column, with up to 6 subjects for one book, all in one field.
Subjects are preceded with "1. "; "2. ", "3. " etc. ...

Hello I have a query that I want to divide the employees delay time by the
employees worked time. I made this query which works but the decimal place is
in the wrong spot. I am looking for a percentage like this 35% but its giving
me 353% I have the decimal place set at 0. What ...

I have a database for use in a martial arts school for registration, and have
created a table (Members) for parent information and (Students) for student
information.  Member ID is the primary key in Members and Student ID in
Students.  

Hi, I am thinking about migrating and combining our current costings systems
in to Access, if it's able to achieve this for me.  Currently we use two
Excel spreadsheets, one which contains static data (linehaul, vehicle,
labour, materials and summary page with commonly used ...

I have setup an OnTimer event on one of my forms. One of the first things
it does is check to see if the db is configured to run the "automatic
check".  It does this by checking a flag in the database.  If it is
configured to run this check, it will run the procedure. If it is ...

The SQL statement could not be executed because it contains ambiguous
outer joins. To force one of the joins to be performed first, create a
separate query that performs the first join and then include that
query in your SQL statement. (Error 3258)

I am having trouble finding out how to add multiple records from a lookup
table to a single record in another table.
Tables:
Metro Areas (just a look up table)

I've created a database that includes things like phone number, email address
and web address.  My employer wants to be able to click on a link in the data
base and have the website open up and active.  Is that possible?  The other
option would include would I guess have me ...

Could someone please help me with this, I know the questions been asked
before. I've tried to follow tutorials on the internet, but I just can't
seem to crack it.
So I can get the concept of how it works, would someone be kind enough to

I'm currently using a table that consists of about 300 columns and is filled
with records. Now, how can I duplicate a specific record (identified by a
automatically growing unique ! integer)? I've tried INSERT INTO SELECT
statements, but unfortunately, as the table does not ...

How do I change the month from January to March without changing the number
in individual boxes?

I am trying to create a database that lets me keep track of running
performances and rank them against one another.  I have created a
table named Races that contains: runner_id, racename, date, distance,
and seconds.

I buiot a database using 2007, the rest of my colleagues only have Office
2003 and I can not find a way to save it as 2003, this will mean another 2
weeks of work 20 hrs a day to redo it in 2003.  HELP please

I would like to have a very small data base application running on a Palm
III or other similar PDA.  I am familiar with Access and wonder if I created
a runtime version of the application I could load it on to a PDA and have it
do its thing.

Hi all.  I am using Access 2003 with a 2002-2003 file structure.
I have a table T1
I have a select query Q1 for which the sole data source is T1
I have a select query Q2 for which the sole data source is Q1