Re: table design
- From: "Alex Dybenko" <alexdyb@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 15 Apr 2009 18:01:14 +0400
Yes, this could a reason. But can you compile your project? Access will tell you then in some reference missing
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
"angie" <angie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:07ED6DF1-88B7-4F27-8E77-1E2E56E1F44E@xxxxxxxxxxxxxxxx
yes, i have corrected it, but i still get the same error message. could it be.
something with DAO reference missing from my module?
Ο χρήστης "Alex Dybenko" έγγραψε:
I think you missed one parameter, tablename:
SELECT CODE, fConcatFld("TableName","CODE","VEHICLES","string",[CODE])
--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
"angie" <angie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0AA4C3B9-CE58-427F-A587-D2C14164A612@xxxxxxxxxxxxxxxx
> hi, it seems that there was something wrong with the module name. > anyway i
> have got the query now but when i run the query i get the error message
> "error #13, type mismatch". any idea what the problem might be?
>
> Ο χρήστης "Alex Dybenko" έγγραψε:
>
>> Hi,
>> no, primary key absence should not be a reason, for some reason >> function
>> is
>> not found. Did you save new module? did you compile project?
>>
>> -- >> Best regards,
>> ___________
>> Alex Dybenko (MVP)
>> http://accessblog.net
>> http://www.PointLtd.com
>>
>>
>> "angie" <angie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:DA784029-F13D-4E49-BDBC-F93FA97F73E6@xxxxxxxxxxxxxxxx
>> > i have tried this in northwind database and it works fine. in my
>> > database
>> > i
>> > get the error message "undefined function fconcatfld in expression". >> > i
>> > have
>> > created the module and the sql of my query is:
>> >
>> > "SELECT CODE, fConcatFld("CODE","VEHICLES","string",[CODE]) AS
>> > [BRANDS-TBL]
>> > FROM [BRANDS-TBL]
>> > GROUP BY CODE;"
>> >
>> > what could i be doing wrong? maybe it is because there is no primary
>> > key
>> > in
>> > my table?
>> >
>> >
>> > Ο χρήστης "Alex Dybenko" έγγραψε:
>> >
>> >> Hi,
>> >> try this approach:
>> >> http://www.mvps.org/access/modules/mdl0008.htm
>> >>
>> >> -- >> >> Best regards,
>> >> ___________
>> >> Alex Dybenko (MVP)
>> >> http://accessblog.net
>> >> http://www.PointLtd.com
>> >>
>> >>
>> >> "angie" <angie@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> >> news:5E00456C-3C45-4D71-8C03-A42F70B07380@xxxxxxxxxxxxxxxx
>> >> > i have a table with two fields: code and vehicles. no primary >> >> > key.
>> >> > each
>> >> > code
>> >> > can correspond to many vehicles: e.g. CIP = citroen (one record),
>> >> > peugeot
>> >> > (another record). i want to create a query or a report that shows
>> >> > the
>> >> > records
>> >> > as follows:
>> >> > CIP = citroen, peugeot.
>> >> > can i achieve something like that?
>> >>
>> >>
>>
- References:
- table design
- From: angie
- Re: table design
- From: Alex Dybenko
- Re: table design
- From: angie
- Re: table design
- From: Alex Dybenko
- Re: table design
- From: angie
- Re: table design
- From: Alex Dybenko
- Re: table design
- From: angie
- table design
- Prev by Date: Re: insert an excel sheet
- Next by Date: Re: insert an excel sheet
- Previous by thread: Re: table design
- Next by thread: Event fired in class module (revisisted)
- Index(es):
Relevant Pages
|
