Beta query

  • Thread starter Thread starter DBarselow
  • Start date Start date
D

DBarselow

Hi,
I seem to have developed a problem that I just can't seem
to hunt down. It started when I installed office2003 in
it's own Partition. I wanted to uninstall it to clean up
some unwanted tables and other files. When i tried to
work with Office97 (Access) that I have installed in my
default dir. the query dont work function does not work.I
reinstalled office2003 in the partition that I made and
now the query function only works if I do a complete
query, and not when I want to use criteria selections.I
need to solve this problem fast and have not been getting
to many responses.

ThankYou all DBarselow
 
Could you share
-your sql
-any error messages ("doesn't work" tells us very little)
-do any queries work criteria
-how are you creating the criteria
 
-----Original Message-----
query
I get what's expected, that is when I add all the fields
in that is in the database in to the query I can recieve a
full complete query of the database. But once I attempt to
do a a single field say for instance in the address field
of 200 or so entries and try to pull up all the entries in
NY. I get nothing I get the empty field in a empty query I
mean the field in the query is empty. I thought I was on
to something last night when I thought it may have been
something to do with rows being deleted in the results or
something but couldn't had no results. I will send the SQL
string once I get back to own workstation. I am at School
at this time.
DBarselow.
.
here is the sql that I took from sql view
Click to expand...
SELECT [Cruises#400].F1, [Cruises#400].F2,
[Cruises#400].F3, [Cruises#400].F4, [Cruises#400].F5, *
FROM [Cruises#400]
WHERE ((([Cruises#400].F3)="ny"));
 
Back
Top