Update Query

[paulmitchell507]

I am using Access 2000 and I would like to update a field using an
update query. Lets call the field that I would like to update
[table1]![hyperlink]. Table1 also contains a field called [table1]!
[email]. I would like to update [table1]![hyperlink] to show the
following,

"testsmith@virt ualworld.net" where smith@virtualwo rld.net is stored in
[table1]![email]

If I enter the following into my updateto query, "test" & [email] I
can't display the " at the beginning and end of the field.

How can I add the "" to [table1]![hyperlink] field via an update
query?

I must be simple syntax to get the " at the start and end of the
field, but I don't know it.

Regards,

Paul

[Roger]

Re: Update Query

On Jul 16, 3:54 am, paulmitchell507 <paulmitchell.. .@googlemail.co m>
wrote:

I am using Access 2000 and I would like to update a field using an
update query.  Lets call the field that I would like to update
[table1]![hyperlink].  Table1 also contains a field called [table1]!
[email].  I would like to update [table1]![hyperlink] to show the
following,
>
"testsm...@virt ualworld.net" where sm...@virtualwo rld.net is stored in
[table1]![email]
>
If I enter the following into my updateto query, "test" & [email] I
can't display the " at the beginning and end of the field.
>
How can I add the "" to [table1]![hyperlink] field via an update
query?
>
I must be simple syntax to get the " at the start and end of the
field, but I don't know it.
>
Regards,
>
Paul

if you want the field to contain the double quotes you need to pair
them up
""test"" & [email]

[paulmitchell507]

Re: Update Query

On Jul 16, 11:03 am, Roger <lesperan...@na tpro.comwrote:

On Jul 16, 3:54 am, paulmitchell507 <paulmitchell.. .@googlemail.co m>
wrote:
>
>
>
>
>

I am using Access 2000 and I would like to update a field using an
update query.  Lets call the field that I would like to update
[table1]![hyperlink].  Table1 also contains a field called [table1]!
[email].  I would like to update [table1]![hyperlink] to show the
following,

>

"testsm...@virt ualworld.net" where sm...@virtualwo rld.net is stored in
[table1]![email]

>

If I enter the following into my updateto query, "test" & [email] I
can't display the " at the beginning and end of the field.

>

How can I add the "" to [table1]![hyperlink] field via an update
query?

>

I must be simple syntax to get the " at the start and end of the
field, but I don't know it.

>

Regards,

>

Paul

>
if you want the field to contain the double quotes you need to pair
them up
  ""test"" & [email]- Hide quoted text -
>
- Show quoted text -

Thank you Roger, I also found that Chr(34) does the trick!

[Keith Wilby]

Re: Update Query

"paulmitchell50 7" <paulmitchell50 7@googlemail.co mwrote in message
news:58b07540-654f-4af4-a064-aea9fc69cfc2@j2 2g2000hsf.googl egroups.com...

>I am using Access 2000 and I would like to update a field using an
update query. Lets call the field that I would like to update
[table1]![hyperlink]. Table1 also contains a field called [table1]!
[email]. I would like to update [table1]![hyperlink] to show the
following,
>
"testsmith@virt ualworld.net" where smith@virtualwo rld.net is stored in
[table1]![email]
>
If I enter the following into my updateto query, "test" & [email] I
can't display the " at the beginning and end of the field.
>
How can I add the "" to [table1]![hyperlink] field via an update
query?
>
I must be simple syntax to get the " at the start and end of the
field, but I don't know it.
>
Regards,
>
Paul

Quotation marks are reserved characters in Access so dealing with them may
be more trouble than it's worth, but if you have no option then enclosing
them in quotation marks might be worth a try, ie """ & "test" &
[table1]![email] & """ Then again I could be completely wrong as I've never
tested this scenario.

Keith.
www.keithwilby. com

[Salad]

Re: Update Query

paulmitchell507 wrote:

I am using Access 2000 and I would like to update a field using an
update query. Lets call the field that I would like to update
[table1]![hyperlink]. Table1 also contains a field called [table1]!
[email]. I would like to update [table1]![hyperlink] to show the
following,
>
"testsmith@virt ualworld.net" where smith@virtualwo rld.net is stored in
[table1]![email]
>
If I enter the following into my updateto query, "test" & [email] I
can't display the " at the beginning and end of the field.
>
How can I add the "" to [table1]![hyperlink] field via an update
query?
>
I must be simple syntax to get the " at the start and end of the
field, but I don't know it.
>
Regards,
>
Paul

For future reference...

If you entered "test#" & Email you get
Test#Emailvaulu e
into a hyperlink field it will display Test, not the actual email
address, to the user for pressing on to execute the link to the address.

Ex: ClickMe#http:ww w.test.com will only display ClickMe.

Sour Times
http://www.youtube.com/watch?v=6OdUzET U6cI