Re: Concatenate error - Duane Hookom's concat function
- From: "Al Campagna" <alcampagna@msnewsgroups>
- Date: Wed, 17 Jan 2007 21:56:21 -0500
Kat,
Since Region is a text field it should be in it's own quotes...
"Region = '" & [Region] &"'"
I'll put spaces in the quotes for clarity, but don't use them in the code...
"Region = ' " & [Region] & " ' "
--
hth
Al Campagna
Candia Computer Consulting
Microsoft Access MVP - Candia, NH USA
http://home.comcast.net/~cccsolutions
"Find a job that you love, and you'll never work a day in your life."
"Kat" <Kat@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E8548303-353A-4640-ADC1-4822BF2FD1A4@xxxxxxxxxxxxxxxx
I followed the Duane Hookom's directions for setting up a concatenate
function in my database. As far as I can tell it's all set up correctly...
I copied the basConcatenate function over to my database and in my query I'm
using the VBA code:
RegionTest: Concatenate("SELECT CongregationName FROM tblCongregation WHERE
Region =" & [Region])
But when I run the query, it comes up with an error for each row:
Run-time error '-2147217900 (8004e14)':
Syntax error (missing operator) in query expression 'Region =North West'.
(ie where the row is for the North West region)
What have I done wrong??
How do I fix it??
Please help!
.
- Prev by Date: Report Generator
- Next by Date: RE: Sum Less Than
- Previous by thread: Report Generator
- Next by thread: Re: Concatenate error - Duane Hookom's concat function
- Index(es):
Relevant Pages
|
