I have two tables - PO and PODetail. The PO table tracks such things
as date, po number, vendor, etc. The PODetail table links to the PO
table and contains detail information such as item, account number,
quantity and paid status. If there is a PO with 5 PODetails, each

In attempting to troubleshoot some problems in a query, I noticed that
three of the fields (design mode of Access 2000) showed "Expr 1014",
"Expr 1015","Expr 1016".  Data exists in the fields when I execute the
query.  What does this mean?

I have an order-table with a column named "animalID". Some of the
animalID-records are duplicated. I would like to have a querry with only
unique animalID-records from both the duplicates and the rest of the records.
I.e. if there are 3 records of "123", 2 records of "456" and 1 ...

I have a Query with Email addresses and another Query with account numbers
and dollar amounts.  Does anyone know how to insert the data from the Query
with account numbers so that it goes to the individual email address?  Thanks
in advance for your help.

I use Access 2007  (12.0.6211.1000) SPq MSO (12.0.6213.1000)  in the
connection with SQL Server 2000 and the tables linked using SQL ODBC driver.
One of my saved "group by" queries seeks for all the serial numbers of  our
stock on the fixed day and the other simple query seeks for ...

At work I use access with ODBC to connect to our oracle database. I'm a
meteorologist. I pull down data for a particular station and can crunch all
kinds of climate data for it. Anyway, to speed things up I use a pass
through query as the front end of a make table query. Normally ...

I am trying to get a query to return all records even if the field is null.  
The query has multiple tables and is only returning records with non null
fields.  I am using the following line in the query.  The result were the
same.  I would be greatful for any help.  Thank you ...

i am trying to export a report into an exel file.  I have used
conditional formatting to highlight few records in the report. Now
when i export it to exel t that formatting no longer exists. Is there
a way to export a Access report to exel while still maintaing the

I believe the Microsoft Office 2007 has already been installed when I
purchased my Toshiba A200 satellite as it is already written in the program.
However, when I am trying to test said program I always been asked to type
the product key.

In a query, how do I get a percent sign to appear after a number. I have a
column of numbers and would like percent signs after each number. Thanks!

In SQL View, I deleted a selection of the form [Table].[Field] AS EYear
Windows XP SP2
Access 2007
When I run the query, a pop-up appears, asking for the value of EYear.

I have an insert query running on SQL Server. I can run delete queries from a
module in an Access adp using this syntax.
CurrentProject.Connection.Execute "DELETE FROM dbo.HoldTerm"
This works fine and returns to the module to run the next line of code.

On a query field lets say for an item # field, in the criteria can I
put
like "123456" or "123457" etc for as many items as I want, either 1 or
100? What would be the best way to do this if I have a lot of item #'s

I have two tables: Table1 contains the fields "CaseDigits" and
"OldNotes". Table2 contains the fields "CaseDigits" and "NewNotes". In
Table2, CaseDigits is unique, but there may be numerous matching
records (on the CaseDigits field) in Table1.

I have a query with 3 tables that represent master item list, count qty and
as qty. When I look at the results in Query, all is well and accurate yet
when I select Analyze with Excel, values change. For example, if a record
shows zero qty in the as of field and zero quantity in ...