ACCESS and Lookup function

[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

 

[Van T. Dinh]

Not sure what you are trying to described and how it is related to Access??

 

[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.
==================

 

[tina]

Lookup Function? Lookup box? in an Access query? do you mean the *criteria*
lines in the grid in query design view?

 

[Van T. Dinh]

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 ...

 

[tina]

another example of why it's important for new Access users to learn and use
the correct terminology, so they can communicate effectively.