Re: fields are missing when I try to select them as a Group Level
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Tue, 7 Aug 2007 00:07:32 +0800
Try changing it to a Text field (size = 255.)
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Widdy" <Widdy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:93366EE9-0F0C-4980-8490-7EDC38761494@xxxxxxxxxxxxxxxx
Hi,
I am trying to group on a memo field, but it is a memo field because that
field contains all of the user defined variables in our database and they can
be anything, but the only ones I am using to group by are the page numbers of
our catalog which will be from page 4 to page 31, so truncating is not a
problem.
Can it be done?
Ian
"Allen Browne" wrote:
You're trying to group on a memo field?
Not a good idea. Even if you can get it work, it will probably truncate to
255-characters.
"Widdy" <Widdy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3788428D-F6D4-4CD9-81FA-210799B1585D@xxxxxxxxxxxxxxxx
> Hello,
>
> I tried to select the Svalue in the dialog but could not, I also could > not
> select the
> ShortDescription. I have removed the last bit to leave just
> SELECT Product.[Product Reference], Product.[Short description],
> Product.Price, UserDefinedProperties.sValue
> FROM UserDefinedProperties INNER JOIN Product ON
> UserDefinedProperties.sContentID = Product.[Product Reference]
> WHERE (((UserDefinedProperties.nVariableID)=65879));
> but that has not helped, I then removed a bit more which left the > below,
> it
> did not help either.
> SELECT Product.[Product Reference], Product.[Short description],
> Product.Price, UserDefinedProperties.sValue
> FROM UserDefinedProperties INNER JOIN Product ON
> UserDefinedProperties.sContentID = Product.[Product Reference];
>
> After checking my database, both the missing fields' data type is MEMO,
> could that be something to do with the problem?
.
- References:
- Re: fields are missing when I try to select them as a Group Level
- From: Allen Browne
- Re: fields are missing when I try to select them as a Group Level
- From: Allen Browne
- Re: fields are missing when I try to select them as a Group Level
- From: Allen Browne
- Re: fields are missing when I try to select them as a Group Level
- From: Allen Browne
- Re: fields are missing when I try to select them as a Group Level
- Prev by Date: Re: Hide/Limit Records in a Report
- Next by Date: Re: print different report based on value in control
- Previous by thread: Re: fields are missing when I try to select them as a Group Level
- Next by thread: Re: filtering results shown on report / subreports based on queries
- Index(es):
Relevant Pages
|
