simple query no data found

  • Thread starter Thread starter starfighter001
  • Start date Start date
S

starfighter001

built a database where table 1 fields take their data from a second table
which is used as a list eg table 1 field Authors name will pull its data from
table List of authors.this was set up using look up wizard. when i run a
query to find a name i get nothing. if i run the same query on manually
entered data in table 1 the query works . i am guessing i must link the two
tables together but not certain how.
the criteria i put in to the search is correct as i know how to put in part
word searches and single letter searches tried all these. i will willing
email the rough database to anyone if it helps


thanks

sf
 
built a database where table 1 fields take their data from a second table
which is used as a list eg table 1 field Authors name will pull its data from
table List of authors.this was set up using look up wizard. when i run a
query to find a name i get nothing. if i run the same query on manually
entered data in table 1 the query works . i am guessing i must link the two
tables together but not certain how.
the criteria i put in to the search is correct as i know how to put in part
word searches and single letter searches tried all these. i will willing
email the rough database to anyone if it helps


thanks

sf
Click to expand...

You're another victim of Microsoft's misdesigned, misleading Lookup Field
type. Your table *APPEARS* to contain the author's name, but it doesn't: it
contains only a numeric ID field, concealed behind the combo box which
displays the author's name from a different table. That's why your query isn't
working: you're searching for "Shakespeare" but the table contains (invisibly
to you) 3127.

See http://www.mvps.org/access/lookupfields.htm for a critique of this
feature.

To create your query add both your table and the Authors table (the one you
use for the lookup) to the query design window; they should automatically be
linked by the AuthorID. You'll then have all the fields from your table, and
the author name field from the authors table; by can apply criteria, or a
sort, or whatever, to that field.
 
Back
Top