In an Excel worksheet I have the following data:
    4000    3000    2000    1000
400    170    130    90    50
300    160    120    80    40

I am attempting to track invoices and payments for customers, and appending
"paid" invoices to a new table.  Invoices and payments are entered by invoice
number.  I currently have a duplicate query that finds my duplicate records
perfectly.  However, I want to find duplicate ...

I have a database with two text fields that contain numbers and letters that
correspond to rule citations. I am trying to filter the database by trying to
match the rule citation string in one field (in that field there are no
letters, just numbers separated by a ".") with a ...

I am having an off-day today and am not able to figure out how to get the
results I want from just one query. Instead I made multiple queries that
cascade from each other. But, I want to combine these queries together into
one query. Basically, I am trying to correct the ...

Hi, I have a query where I am using an iif statement so that my field
we either equal text or number depending on the value of another
field. Here is my iif statement
Portfolio1:

Can anyone tell me where I can find the "Replication Group"?
I am having a problem with a replicated database in Access and was referred
to the Replication Group.
Thanks,

How can I enter date parameters for a crosstab query? I have used the where
date is between this and that expression in other queries however it will not
work in a this one.

I have a query that I am needing to pull certain data from a table. I have
been able to get this query to work if I plug in the criteria manually that I
am needing to filter. However, when I setup the criteria to pull it from a
text box on a form then the query returns no results ...

I have a file that I've pulled into Access.  When the information downloaded,
it didn't completely fill in some data, i.e. I have a customer column and an
SIC Code file.  In the SIC code column, I want all occurances of the customer
number to contain the same SIC code.  My file ...

I edited a query in Access 2007, and when I try to open in in Access 2000,
the program disappears from the screen.  No error message, nothing.  Just
gone.
How can I recover the database.  Repair/Compact made no difference.

I have created a blank database in Access 2003.
Now I want to create tables using scripts from queries, is it possible?
And how if it is possible?

I am trying to transfer infomation from a form to another table other than
the one I am using whenever the user check in a box.  I need some help on
tell me how I can do this.  It seems everything I try I get and error.  Can
someone tell me how I can do this????

I am setting up a phone book
I have set up the query [What Company]
When I run the query and the Prompt Box asks for the company name, I cannot
get it to produce any companies that I do not know the correct spelling for

I'm trying to do a rolling average on data that is ordered by a date
time column.
I'm after adivce about how best to do this, I've tried this -
SELECT Time, ValueX, (HOUR(Time) * 3600 + Minute(Time) * 60 +

I have two tables. Table A has new data being entered daily and also some
data that is being updated. TABLE B is a master table that has data from
every month. I want to know how to add the new data from Table A into Table B
and update the data that has been changed in Table A ...