Create Table query - need help

  • Thread starter Thread starter Charlie Helfrich
  • Start date Start date
C

Charlie Helfrich

I have several Paradox tables linked into Access. Trying
to configure a make table query that would include a
couple of fields from the linked data and place new field
in make table query with a path statement to network drive
and data from other fields place after path statement,
with build expression.
Example would be: j:\photos\00100080013005001.jpg

where 0010008001300 are from one field and 5 from 2nd
field and 001 from 3rd field, then add the .jpg
 
Dear Charlie:

I sounds like this would only require some string manipulation, specifically
the concatenation of the two strings, being the network drive path and the
file name, plus, perhaps, the file extension.

You would have the choice of hardcoding the network drive and path or you
could put them into a table so they would be persistent but could be
modified from a form. The latter is nice for its power and flexibility.

In the make table query, the SELECT statement might something like:

SELECT . . ., "j:\photos\" & FileNameColumn & ".jpg"

Your original post is a bit sparse on detail, so I'm trying to respond in a
general way, but I'm also making assumptions that may be wrong. Perhaps you
can post more detail to overcome my ignorance of what you want.
 
Back
Top