Here is the code:  UPDATE [Results Table] SET [Results Table].ResultID =
Import.ResultID, [Results Table].Q1 = Import.Q1, [Results Table].Q1T =
Import.Q1T, [Results Table].Q2 = Import.Q2, [Results Table].Q2A = Import.Q2A;
This is just a portion of the code.  I import the data from ...

Hello, I have an invoice table that includes the fields CustomerNumber and
DivisionNumber.  Customers can deal with multiple divisions.
CustomerNumber     DivisionNumber
ABC Co                    10

I have a query that shows many records with the same "Part Number".  I want
to create a query that shows only the Part Numbers without duplications.
Any ideas anyone?

I have a frmMultProduction with a multi selection list box(mylist) that has a
RequiredDate, ModelNumber and Description the list row source = qrProdution
qrProduction has RequiredDate, ModelNumber, Description, spring, foam and so
on

Hi All
I have a project where my company needs to record 250+ Username and Passwords
for each team.
I am trying to set up a report to show me only blank fields in the username

I'm probably going about this the wrong way, but I want to know if it
is possible to use a crosstab query to display what I need.
Scenario:  People pay into a lotto syndicate each fortnight.  The
amount is $5.  So in effect, they pay today and they next need to pay

I have a parameter union  query which gets it's criteria from an open form.  
I then have a Crosstab query which uses the union query to return results.
This works fine if I am in the database window.  However, if I try to open
the Crosstab query as a recordset, I get an error ...

I have a form with several queries set to run by macros.  The queries will
run based on the criteria chosen from 1 of the various drop down boxes that
are also located on the form.  When I go to run the query I want it to check
the drop down boxes 1 at a time, and move on to the ...

"Qry_CCode_MT" is a "make table" query that populates records from another
query but I get an error saying it can't be found. Is there something I am
missing to make it work?
The full code in the "on-click" event is the following:

I have a transaction table that has fields such as CustomerID, CustomerName
and Amount.  The Amount field is a general number format which I cannot
change.  I create a make table every day which creates the sales by month for
all customers.  When I create this make table I want ...

Hi. I have a table that have named as querie1 that has record, imagine 1 to
100. I have table2 that have 50 record 1 to 50. Those 50 record of table2 are
equal to 50 record that exists in table1. I need a querie that shows me the
that the does not mach. That shows me the others ...

I have a table that captures when a person logs onto the database.  It
stores their windows logon name, the computer terminal, their department,
and the date/time when they logged on and the date/time when they logged
off.  Its for audit purposes.

Hello Friends,
I have table name 'WorkPerformed'. it has fields Such as
Lot #,  Sublot #, ToDay'sQty
I want Calculated field in Query Using DSUM Expression. The calculate field is

Please, How I can to sum in Access in Query, considering that: my table have
three fileds and I want sum the field in determinated period. I try commands
SQL but i dont get sucessfull.
Can I help me, please

I have seen a similar message but don't quite understand.
I have the following totals query and I want to calculate the number of
times each description occurs as a percentage of the total.
CCode    Type                   Description