I have a problem trying to find the highest value for each row. I have
a query, which adds up scores. Its based on a table something like
this
orgID Score1 Score2 Score3 Score4 Score5 Score6

I have several tables in an Access 2003 database.
On each one I have 4 columns - 2 for 'created by' user and date and two for
'amended by' user and date.
How do I automatically populate these columns on Add new or Update row with

I have a customer tracking program (ADP), and it was originally designed
with teh customer notes as a "text" field.  Then then customer notes woudl
be entered at various times, it would be entered by automatically adding a
lineedn cahracter, followed by the date, followed by the ...

hi gurus!
I have an Append query which is inerting records into a table with a
Hyperlink Data column. The query formats the path eg "PDF/fielname.pdf" and
appends it to the field.

Ok, this is my last obstacle on my first Access project. What I have
is a form that users can scroll through all of the shops we deal with,
about 900. On the bottom of this form are buttons A-Z so filter the
form to only shops that start with those letters, and an ALL button to

When I run a query, I will get multiple rows of results (multiple records)
via a spreadsheet format.  I would like to access every cell in the query
results and copy the data to a specific textbox on a form.  If I have 5 rows
of results consisting ot 5 columns of actual data then ...

I am familiar with using SQL statements such as "SELECT TOP !) FROM
...", but I have a situation that has me stumped. I have a table similar
to this (but with thousands of individuals):
NAME    SCORE    AVERAGE

Well, that's the best description I can think of anyway.
I need help with a solution. I have a set of data (vehicles) that I
have managed to extract a complete history for. This dataset shows the
month and year of every inspection that was completed on the vehicle

Hey I am new here I am sorry if I am about to confuse you But I need some
help and I cant figure this issue out. I am creating a table in access. The
data I need is in several different excel files. all structured the same.the
only thing that will change it the location of the item. ...

I have a query with criteria that looks at a field on a table that refers to
a Lookup table.  Currently, I have the criteria ask the user to type the text
for the field.  I would rather have the user select from the options on the
look-up table to avoid mispellings...how can I ...

I have created a query with criteria that asks the user for a status.  The
status will never change and when entering the data initially, the user will
choose from a drop down list for status.  How can I create the query dialog
box such that they will again see the drop down list ...

This query runs very slow. There are around 19,000 records in each table.
Both TicketNo and TicketID are indexed.
SELECT TicketNo, Keywords
FROM tblCSTickets

I need help!  Please bear with me so that I can explain what it is I'm trying
to accomplish.
I'm using queries to create time sheets for staff by tallying the total
amount of time spent working in each of several possible programs within

I've inherited a database that relies heavily on a non normalized table.  
Until I can convince the general manager that I can normalize the data
without losing any records, I've got to have a workaround for certain
situations.  Namely, I need to ensure that data is not being ...

I have a crosstab query that list the "year" field as rows and the "species"
field as columns.  The query counts the number of birds seen each year for
each species.  As an example the output looks like:
           CRLA         SSSN       SPSX