ACCESS and Lookup function

  • Thread starter Thread starter Jonah
  • Start date Start date
J

Jonah

Is there an easier way to set a Lookup function rather than having to
create a .csv or text file including " " around every item?

I wondered if I used a .csv in Excel and saved the file as a .csv it
might add commas which I could then replace with semi colons.

How does Excel get to add " " marks automatically around a data record
item?

Jonah
 
In the Lookup Function of Access queries, there must be an easier way of adding
Lookup commands to the qrytable at the bottom of the screen. I wondered if a
..csv file might be an easy way to build it rather than type in a list of items.

Example: I go on the WWW and find a list of twenty colours.
I paste this into the Lookup box.
OR
I want to edit the table adding in several new items.
SO
I need to add " and " around each item - (not easy here)
I need to add a semi colon between each item. (Manual method
only.)

SOLUTION
If I do this in Notepad it should be easy to add "" and the
semicolon by using edit and replace.
==================
 
Lookup Function? Lookup box? in an Access query? do you mean the *criteria*
lines in the grid in query design view?
 
Your guess is as good as mine ... I think Jonah is trying to establish a
criterion using the In Clause with a list of String values ...

It sound like a LookUp Table and a SubQuery in the original Query are called
for here ...
 
another example of why it's important for new Access users to learn and use
the correct terminology, so they can communicate effectively.
 
Back
Top