[mso] Re: Ms access query query
- From: Anne Robson <anne.robson@xxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Tue, 28 Apr 2009 13:56:56 +0100
Are the other values in standard case - eg Dundee rather than DUNDEE? Not
sure if this would have the effect you describe but it might!
2009/4/22 Rachel Jobes <racheljobes@xxxxxxxxx>
> Thanks iv checked and rechecked that. The value not being picked up is
> the word DUNDEE. Iv compared the queries that work against the 1 that
> doesnt and there r no differences. I will keep on the trail though
>
> On 4/22/09, David Grugeon <david@xxxxxxxxxxxxxx> wrote:
> > Without seeing the query and the value it is not picking up it is
> impossible
> > to guess. However some things you might check are:
> >
> > The letter O typed as a zero or vice versa
> > The letter l typed as a number 1 or vice versa
> > Extra spaces at the beginning or end of the word (use trim on both the
> query
> > expression and the item searched)
> > Hard (non breaking) spaces instead of normal spaces in the word
> > Quotation marks issues including smartquotes, single to double, etc.
> >
> >
> > Best Regards
> >
> > David Grugeon
> > Grugeon Consulting
> > (07) 3263 7786
> >
> > Original message:
> >
> >
> >> -----Original Message-----
> >> From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx] On
> Behalf
> > Of Rachel
> >> Jobes
> >> Sent: Wednesday, April 22, 2009 7:05 PM
> >> To: mso@xxxxxxxxxxxxx
> >> Cc: Linda F. Johnson
> >> Subject: [mso] Ms access query query
> >>
> >> I have a very simple database the tables have no relationships and at
> >> the moment are imported from excel.
> >> i have 5 tables each of these hav a simple query to list and count the
> >> number of occurences of office names. All but 1 query work they are
> >> all identical but 1 will not pick up a value.
> >> the value is definately in the table but is missd out wen i run my
> >> query. If i change the value to another it is then picked up. Even if
> >> i add a 1 to the end of the word it is picked up. Iv re did the query
> >> many times and re importd the table and its only eva this value. Any
> >> thoughts.
> >> Thanx
> >>
> >> On 4/1/09, Frank C. <jocaan@xxxxxxxxxxx> wrote:
> >> > I do have a long list of Mail Folders. Under MAIL on the left side I
> > have 4
> >> > folders in Favorite Folders. Then under Mail Folders I have over 40
> >> > folders. I'm not referring to the vertical scroll bar I'm referring
> to
> > the
> >> > smaller horizontal scroll bar at the bottom of the Mail Folders list
> > that
> >> > will move the folder icons off to the left and leave the name of the
> > folders
> >> > only. I want to do this so my reading screen is a little larger and I
> > see
> >> > more of the name of the folder-I don't need to see the folder icon.
> In
> >> > Outlook Express the horizontal scroll bar is always there. At first
> > when I
> >> > started using Outlook the horizontal scroll bar was not there, and
> then,
> > I
> >> > forget how, the horizontal scroll bar did appear but then it went away
> > and
> >> > now of course, I do not have it again. Frank C.
> >> >
> >> >
> >> > From: Linda F. Johnson [mailto:linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx]
> >> > Yes, you can only post thru emails ... to search to see if your
> > question
> >> > has been answered, go to the archives and use the search feature there
> > ...
> >> > the archives are here:
> >> >
> >> > //www.freelists.org/archive/mso
> >> >
> >> >
> >> >
> >> > The scroll bar in Outlook's Mail Folders section is only visible when
> > you
> >> > have too many folders to display ... if all of the folders are
> showing,
> > then
> >> > the scroll bar isn't necessary and doesn't show. If you want to see
> it,
> > you
> >> > will have to make your Outlook Window small enough that not all
> folders
> > show
> >> > ... or add more folders
> >> >
> >> > Linda
> >> >
> >> > *********************************
> >> >
> >> >
> >> >
> >> > From: Frank C. [mailto:jocaan@xxxxxxxxxxx]
> >> > Sent: Wednesday, April 01, 2009 3:56 PM
> >> > To: mso-moderators@xxxxxxxxxxxxx
> >> > Subject: How to post, How to search files
> >> >
> >> >
> >> >
> >> > Do you only post to this group through emails? Is there any other
> > listing
> >> > of messages besides the archive where you can go to read recent,
> > compiled
> >> > posts and answers? Before I post, I have a question about how to
> > activate
> >> > the horizontal scroll bar at the bottom of the Mail Folders section in
> >> > Outlook, is there a way to search to see if this question has been
> > answered
> >> > before?
> >> >
> >> > Thanks, Frank C.
> >> >
> >> >
> >> >
> >> > *************************************************************
> >> > You are receiving this mail because you subscribed to
> mso@xxxxxxxxxxxxx
> > or
> >> > MicrosoftOffice@xxxxxxxxxxxxxxxx
> >> >
> >> > To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
> >> >
> >> > To Unsubscribe from this group, visit the group's homepage and use the
> >> > dropdown menu at the top. This will allow you to unsubscribe your
> email
> >> > address or change your email settings to digest or vacation (no mail).
> >> > //www.freelists.org/webpage/mso
> >> >
> >> > To be able to share files with the group, you must join our Yahoo
> sister
> >> > group. This group will not allow for posting of emails, but will
> allow
> > you
> >> > to join and share problem files, templates, etc.:
> >> > http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is
> for
> > FILE
> >> > SHARING ONLY.
> >> >
> >> > If you are using Outlook and you see a lot of unnecessary code in your
> > email
> >> > messages, read these instructions that explain why and how to fix it:
> >> > http://personal-computer-tutor.com/abc3/v28/greg28.htm
> >> > *************************************************************
> >> >
> >> *************************************************************
> >> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxxxx
> >> MicrosoftOffice@xxxxxxxxxxxxxxxx
> >>
> >> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
> >>
> >> To Unsubscribe from this group, visit the group's homepage and use the
> > dropdown menu at
> >> the top. This will allow you to unsubscribe your email address or
> change
> > your email settings
> >> to digest or vacation (no mail).
> >> //www.freelists.org/webpage/mso
> >>
> >> To be able to share files with the group, you must join our Yahoo sister
> > group. This group
> >> will not allow for posting of emails, but will allow you to join and
> share
> > problem files,
> >> templates, etc.: http://tech.groups.yahoo.com/group/MicrosoftOffice .
> > This group is for FILE
> >> SHARING ONLY.
> >>
> >> If you are using Outlook and you see a lot of unnecessary code in your
> > email messages, read
> >> these instructions that explain why and how to fix it:
> >> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> >> *************************************************************
> >
> > *************************************************************
> > You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxxxx
> > MicrosoftOffice@xxxxxxxxxxxxxxxx
> >
> > To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
> >
> > To Unsubscribe from this group, visit the group's homepage and use the
> > dropdown menu at the top. This will allow you to unsubscribe your email
> > address or change your email settings to digest or vacation (no mail).
> > //www.freelists.org/webpage/mso
> >
> > To be able to share files with the group, you must join our Yahoo sister
> > group. This group will not allow for posting of emails, but will allow
> you
> > to join and share problem files, templates, etc.:
> > http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
> FILE
> > SHARING ONLY.
> >
> > If you are using Outlook and you see a lot of unnecessary code in your
> email
> > messages, read these instructions that explain why and how to fix it:
> > http://personal-computer-tutor.com/abc3/v28/greg28.htm
> > *************************************************************
> >
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, visit the group's homepage and use the
> dropdown menu at the top. This will allow you to unsubscribe your email
> address or change your email settings to digest or vacation (no mail).
> //www.freelists.org/webpage/mso
>
> To be able to share files with the group, you must join our Yahoo sister
> group. This group will not allow for posting of emails, but will allow you
> to join and share problem files, templates, etc.:
> http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for
> FILE SHARING ONLY.
>
> If you are using Outlook and you see a lot of unnecessary code in your
> email messages, read these instructions that explain why and how to fix it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> *************************************************************
>
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
To be able to share files with the group, you must join our Yahoo sister group.
This group will not allow for posting of emails, but will allow you to join
and share problem files, templates, etc.:
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE
SHARING ONLY.
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
