access query with no records

[lparsons]

Hi I have 2 tables with 1 linked field. When I do a query I receive
a report with the headers for the fields but no records. I am
enclosing sql. I would appreciate any help given. Thanks Lois


SELECT [ruanpltytdsept03].[CUST #], [ruanpltytdsept03].[CUSTOMER],
[ruanpltytdsept03].[DEL], [ruanpltytdsept03].[Pick UP],
[ruanpltytdsept03].[DIFFERENCE], [dbo_customer].[ID]
FROM ruanpltytdsept03 INNER JOIN dbo_customer ON
[ruanpltytdsept03].[CUST #]=[dbo_customer].[CUST#]
WHERE (("sum">"0"))
ORDER BY [ruanpltytdsept03].[CUST #];

 

[Rick Brandt]

Hi I have 2 tables with 1 linked field. When I do a query I receive
a report with the headers for the fields but no records. I am
enclosing sql. I would appreciate any help given. Thanks Lois


SELECT [ruanpltytdsept03].[CUST #], [ruanpltytdsept03].[CUSTOMER],
[ruanpltytdsept03].[DEL], [ruanpltytdsept03].[Pick UP],
[ruanpltytdsept03].[DIFFERENCE], [dbo_customer].[ID]
FROM ruanpltytdsept03 INNER JOIN dbo_customer ON
[ruanpltytdsept03].[CUST #]=[dbo_customer].[CUST#]
WHERE (("sum">"0"))
ORDER BY [ruanpltytdsept03].[CUST #];

What is the WHERE (("sum">"0")) supposed to do. All that is doing is comparing
two strings. Do you get records if you remove that?

 

[Van T. Dinh]

The criterion (("Sum" < "0")) is *ALWAYS* evaluated to False since the
*String* "Sum" is different from the *String* "0". Hence there is no Record
returned.

What are you trying to do?

 

[lparsons]

Hi: Thanks for the input. I have two long excel files. I need to
match the salesman's# by Cust# to the other spreadsheet that has
customer information.
Due to their size doing it manually would be tiresome. I have tried it
with and without the greater than zero and with and without the sort.
With the same results. I have many different excel spreadsheets with
different data
that I need to do the same type of thing with. Again, I would
appreciate any ideas.

Thanks
Lois

 

[lparsons]

Hi! Well I finally have some records showing, I was using two files
with approx 2500 records each and now I have 96,000 records. Can
anybody tell me what happened?
Thanks for the help!
Lois

Hi: Thanks for the input. I have two long excel files. I need to
match the salesman's# by Cust# to the other spreadsheet that has
customer information.
Due to their size doing it manually would be tiresome. I have tried it
with and without the greater than zero and with and without the sort.
With the same results. I have many different excel spreadsheets with
different data
that I need to do the same type of thing with. Again, I would
appreciate any ideas.

Thanks
Lois

Hi I have 2 tables with 1 linked field. When I do a query I receive
a report with the headers for the fields but no records. I am
enclosing sql. I would appreciate any help given. Thanks Lois


SELECT [ruanpltytdsept03].[CUST #], [ruanpltytdsept03].[CUSTOMER],
[ruanpltytdsept03].[DEL], [ruanpltytdsept03].[Pick UP],
[ruanpltytdsept03].[DIFFERENCE], [dbo_customer].[ID]
FROM ruanpltytdsept03 INNER JOIN dbo_customer ON
[ruanpltytdsept03].[CUST #]=[dbo_customer].[CUST#]
WHERE (("sum">"0"))
ORDER BY [ruanpltytdsept03].[CUST #];