query results not displaying properly in datasheet view

[Guest]

I have a access 2003 db that is made up of several tables, most of them
linked to a sql server 2k database. I made up a simple query with three
tables joined and a simple criteria to filter the info. The datasheet view I
get displays the wrong info in the field that has the criteria (where name
like '%adobe%'). It displays the correct number of records, but what it
displays are names of other software programs other than adobe. I can export
the query to an excel file and I have the correct info.

What in the world could be causing this? Most of the queries work fine, but
in the last month or so, i've noticied that every now and then, the wrong
info is displayed in the datasheet view, but it is correct when I export it
to excel.

fisk

 

[Van T. Dinh]

Try:

Like "*adobe*"

 

[Guest]

Thanks for the try, but it still has the same results. It pulls up three
records. the three names in datasheet view are completely different that
adobe (not even in the ballpark), but when I export it to excel, it has the
correct information.

Any other suggestions? Anyone?

 

[Van T. Dinh]

Please post your Table structure and the SQL String of your Query.

 

[Guest]

here is my sql statement:

SELECT dbo_AeXInv_AeX_OS_Add_Remove_Programs.Name, dbo_Wrksta.Name,
dbo_Wrksta.[Last Logon User], tbl_maininfo.[User Name]
FROM (tbl_maininfo INNER JOIN pc_name_crossover ON tbl_maininfo.[Asset Tag]
= pc_name_crossover.asset) INNER JOIN (dbo_AeXInv_AeX_OS_Add_Remove_Programs
INNER JOIN dbo_Wrksta ON dbo_AeXInv_AeX_OS_Add_Remove_Programs.WrkstaId =
dbo_Wrksta.WrkstaId) ON pc_name_crossover.pc_name = dbo_Wrksta.Name
WHERE (((dbo_AeXInv_AeX_OS_Add_Remove_Programs.Name) Like '*acrobat 7.0
pro*'));

Two of the tables are linked to an Altiris DB running on a sql server.
Maininfo is a table on a sql server and crossover is just a local table used
to connect info from one table to another.

fisks

 

[Guest]

for some reason this didnt bump back to the top. so i'm bumping it now.

fisk

here is my sql statement:

SELECT dbo_AeXInv_AeX_OS_Add_Remove_Programs.Name, dbo_Wrksta.Name,
dbo_Wrksta.[Last Logon User], tbl_maininfo.[User Name]
FROM (tbl_maininfo INNER JOIN pc_name_crossover ON tbl_maininfo.[Asset Tag]
= pc_name_crossover.asset) INNER JOIN (dbo_AeXInv_AeX_OS_Add_Remove_Programs
INNER JOIN dbo_Wrksta ON dbo_AeXInv_AeX_OS_Add_Remove_Programs.WrkstaId =
dbo_Wrksta.WrkstaId) ON pc_name_crossover.pc_name = dbo_Wrksta.Name
WHERE (((dbo_AeXInv_AeX_OS_Add_Remove_Programs.Name) Like '*acrobat 7.0
pro*'));

Two of the tables are linked to an Altiris DB running on a sql server.
Maininfo is a table on a sql server and crossover is just a local table used
to connect info from one table to another.

fisks

Please post your Table structure and the SQL String of your Query.

 

[Van T. Dinh]

Sorry, I am not sure what the problem is. If the correct data are export to
Excel, the Query is correct.

1. Are you looking at the correct Column? Check the Field names in the
Header row as the order of the Columns in DatasheetView may be different
from the order in the DesignView.

2. Make sure the Query Property "Output all Fields" is set to No / False.

 

[Guest]

I appreciate you trying to help. The problem is that when i'm working on
getting a query to work, it takes trial and error to get it exactly the way I
want it so that it returns the correct info. I dont want to have to export
the results to an excel file and then open it to read it everytime I run a
query. That's what the data sheet view is for. Only one column is not
displaying correctly. The one with the program name.

fisk

Sorry, I am not sure what the problem is. If the correct data are export to
Excel, the Query is correct.

1. Are you looking at the correct Column? Check the Field names in the
Header row as the order of the Columns in DatasheetView may be different
from the order in the DesignView.

2. Make sure the Query Property "Output all Fields" is set to No / False.

--
HTH
Van T. Dinh
MVP (Access)

here is my sql statement:

SELECT dbo_AeXInv_AeX_OS_Add_Remove_Programs.Name, dbo_Wrksta.Name,
dbo_Wrksta.[Last Logon User], tbl_maininfo.[User Name]
FROM (tbl_maininfo INNER JOIN pc_name_crossover ON tbl_maininfo.[Asset
Tag]
= pc_name_crossover.asset) INNER JOIN
(dbo_AeXInv_AeX_OS_Add_Remove_Programs
INNER JOIN dbo_Wrksta ON dbo_AeXInv_AeX_OS_Add_Remove_Programs.WrkstaId =
dbo_Wrksta.WrkstaId) ON pc_name_crossover.pc_name = dbo_Wrksta.Name
WHERE (((dbo_AeXInv_AeX_OS_Add_Remove_Programs.Name) Like '*acrobat 7.0
pro*'));

Two of the tables are linked to an Altiris DB running on a sql server.
Maininfo is a table on a sql server and crossover is just a local table
used
to connect info from one table to another.

fisks

 

[Van T. Dinh]

Sorry, no ideas and I can't see your Query. Unfortunately, it is an SQL
Server back-end so I doubt whether you can post the database to some other
Web sites (e.g. Utter Access) so that I can have a look.