I'm trying to do what I think is probably not too complex but I cannot wrap
my brain around the logic behind it.
In one table, I have Month Booked, Division, and Vehicle #.  What I want it
to do is to compare each Vehicle #'s for Current Month (05/2008)  to last

I have two table with identical information (fields), but one of them is
updated and the other is the one i need to update. I'm doing this in Visual
basic 6 but i've posted here because i'm using sql to do the job.
So, my problem is this:

Currently I export a customer list into Excel along with their YTD or
trailing twelve month sales totals. The sales are summed to find the
total sales of the group and then muliplied by 80%, 15% and 5%. The
customer list is then sorted in descending dollar amounts so that I

I'm having trouble trying to delete duplicate records in a same table.  
What I've got, is one table, that has around 12,000 records.  What it should
have, is around 2,000 records. What has happened, is that the original 2,000
records somehow were duplicated 5 times each, and ...

Assuming:
SummaryTable contains summary info in which the value of several items have
been added together for each transaction. DetailTable contains detailed info
in which a separate record is included for every item composing each

I have a table with 2 rows: Row A, Row B.
There are many rows which are identical. how can I take these
identical rows and make them unique?

Hi, I use access for millions of rows of data and I'm trying to set up a form
with multiple option groups.  I think I'm understanding that pretty well
however I do have a couple of can I do this questions.  1.  I have one option
box that has 6 choices; IPA, County, City, Zip Code, ...

I would like to get a result showing the number of journeys involving 3
particlar locations with any other place lumped in to a single column e.g:-
_______Manchester London Birmingham Other
Manchester

I have a make table query using groups & totals, one of my fields is set to
show the average.  I want to show the average value as a whole number, no
decimals.
I have changed the properties of the field to show as fixed number format

I've a form with 'Unbound' text boxes with 'Format' & 'Input Mask
defined as 'Short Date' i.e. dd/mm/yyyy
Similarly, in the table, the date fields are defined as 'Date/Time'
'Format' & 'Input Mask' as 'Short Date'

I am running data extracts from a multisite inventory table, using the
[enter inv loc] criteria on a "make table" .
Is there a way that criteria can be used to name the output table. as I need
each table to have a unique name.

I am trying to run an append query using a macro and the, Open Query command
. The Query is using information from a form to select the appropriate
records to add to a table. I am running the macro from the same form using
the after update condition.

I need your help please.
I need to create a query that will allow me to compare a students score from
multiple scores of one test and identify which is the highest and note it in
another column.

I am running Access 2003.
I imported an old excel spreadsheet into a single table in Access.  I
need to append data into two related tables as follows:
FirstName, Lastname and Email into tblPersons, which includes an

I am a novice writer of Access Queries and I'm having trouble figuring
out how to do what I want with one query instead of three. Actually,
this will be easier to explain with the example. Okay, here are my
fields: