I ask this question last week, but I didn't explain myself very well.
I have a table with over 187,000 records. From Jan 2001 to today. This table
contains Work Order Information.
These are the main Columns (Table has 15 Columns): Finish Date, WO Prefix,

As a fairly inexperienced Access 2000 user,   I've made several attempts to
follow the example in Northwind to construct my own simple OrderDetails
database, but am missing something, so have turned to modifying the sample
database.

I want to create a front end application.
After I select File|New...
What should I choose from
Blank database...

I have one table with CustID's and contact information, I have another table
with CustID's and answer codes that represent demograpical information.  It
is a one to many relationship.  I need to output a file that is fixed length
and appends the answercodes to specific fields ...

Hello, I have an update query that updates two table fields by 0.83 . One
called DT REGULAR and the other EMPLOYEE TIME. My question is that the query
works but I want to narow down the updates to only rows that have 7.17 for
the EMPLOYEE TIME. What would I use for the criteria? ...

I need to calculate ages based on how old they were when they entered a
program and how old they were when they completed the program. these ages
don't need to be updated just calculated once and for all.
Also I don't know how/where to store the calculation for this

Hello, - I am new to access and trying to create a simple database so i can
track customer information and product purchases.
I don't really know what I am doing but in following the wizards I created a
table of the fields I need.  I am now in the design view and trying to make

I have a table which has differnt numbers in time like 1.77 (thats what shows
in my table) is 1 hour 46 minutes and so on in a field name called DT
Regular. I want to add .83 to each of the times in my table for every record
in the table. The field name is called DT Regular that ...

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 query "Delay Percent: Sum([DT ...

I may be trying to do something that is not possible to do, but here goes:
I am working with three tables. The first one, called students, contains a
list of all students. The second one, called sport, contains a list of
several sports the students could sign up for. A third table ...

How can I put a combobox on a form where the table from which the combobox
choices are drawn has a composite primary key?
Comboboxes only allow you to store one value, but my TransactionDetails
table has OrderID/ProductID as the unique identifier for each record in the

1) On frmEmployeeData, I have a Bound Object Frame named "Photograph".
I also have a tblEmployees with a field named "Photograph". What I
would like is to be enter to put a person's picture on the form and
then it updates the table for that person. The data entry person would

I thought I was putting in a very simple password to protect my Access 2007
database.  Now I can't open any database, because it won't accept the simple
(4-letter) password I enter.  I know it's the correct password and now I
can't open ANYTHING in ACCESS.

PLease help, someone!  I thought I was putting a simple password to protect a
database, now I cannot open ANY database.  It won't accept the password.  I
tried uninstalling Access and reinstalling--same problem.  It says incorrect
password or username and I KNOW the password is ...