I am comparing two large tables (3600 records) using <>.  I have two issues.
1.  One of the sets of column I can see visually match. ALL records in each
column have "N"  yet the results are showing all records as not being equal.  
I have checked the format which is text and the ...

I have written criteria as follows....<[enter date greater than 6 months]....
when run I enter a date 6 months from today and it shows the records I need.  
I would like this to be simplified....but can't figure out how.  What I would
like is when I run the query it automatically ...

I need to append rows from a query to a table and then export this data to
Excel.
I would like to be able to sum the columns with a macro in Excel. The
problem is I have columns in the query which contain numeric values that need

I have a table called "session reports" where the data is entered into it
via a form. At present I can do one member/one session report but I'd like to
be able to add several members to one session (as they can attend solo or in
a group) without re-typing it for each member. I ...

Hello. How can I sum a total of hours. I'm having this problem. When the
total of hours cross 24h it restart, like it was passing to another day.
Exemple: 18.00H+10.00h appears as 04.00h. and I wnat to appear 26.00h.
Con should I format this? In excel I format as [h] and it works, ...

Hi, Please help...
I am new to Microsoft Navision, and have a Access database with tables that
I use. I am trying to understand how I can connect to MS Navision so that I
can build queries from the tables in Navision and the tables in my own

I'd like to test/compare adjacent records to look for duplicate orders
and  missing orders from my shopping cart data.  
I am an Access 2000 newbie.  I had these tests in my db when I used
Excel, but I don't know how to recreate them in Access.

Would very much appreciate expert advice on why it takes a minute to run a
select query, but takes forever to do Make table query on the same set

Hi I am in the process of setting up a contacts database where for some
contacts i am wanting to store Spouse name and birthdate and where applicable
the same for the children all in one record. The fields are as follows (The
assumption is made that everyone shares the lastname ...

I have a table A with data and want to fill another table B with data based
on certain conditions in the first table.
If Field A.Author has a value put A.Author and A.Date in feild B.Author, but
if field A.Autor2 has a value put it and and A.Date in field B.Author instead.

I had encountered tis problem a while back and do not remember if I ever
solved it.
I have created a form with checkboxes.  Once a checkbox is clicked, a click
event procedure is called that adds a string to a list box.  Very simple.

I have 2 Tbl's one Called Search_Tlb  & Documents_Settings_Tbl with the
same fields
In the tbls I have a field called FolderPath, with these records:
C:\Documents and Settings\All Users\Start Menu\Programs\

I am trying to find the best way to find unmatched data.
I have tried this  below and found a few but not all unmatched data, still
having problems.
SELECT Transaktionsrader.Transaktionsrad, Transaktionsrader.Transaktionsnr

I made a query for an invoice. It has several tables in it. One of the tables
is the items that the customer purchased, and one is how they paid.  
The problem is, not all of the customers have paid, but I would like to
generate the invoice, so that if they haven't paid, the ...

I am trying to find the average days between orders and shipments for
2001, grouped by employee. Every time I put the fields in it asks for
ship date and order date. HELP!!!