[mso] Re: Ms access query query
- From: Rachel Jobes <racheljobes@xxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Tue, 28 Apr 2009 19:40:59 +0100
the query actually only groups the offices and count the number of
occurrences.
eg. date (between [enter start date] and [enter end date] max)
office (group by and sort asscending)
incident number (count)
So it should bring up every location eg bristol cardiff dundee edinborough
with a count next to it of how many incidents were for each office.
Its strange - i tried it using the criteria like"Dundee" it still doesnt
pivk up the entries I tried all uppercase and all lower case and it still
doesnt.
It is sooo strange and rather amusing as the list is sorted and all of my
lists look similar this one has a gap there are over 100 occurrences of the
word dundee and it just is not recognised. so weird. Everyone in the
office is quite amused a few of them have reentered stupid stuff like dereks
office and stuff and that picks up in my query but as soon as you put it
back to dundee it doesnt pick up.
At the moment I am busy checking manually through all of my tables and
queries - my managers need to know they can trust the data. if it is only
that that is wrong i will save a find and replace macro and just use the
word dundee. or something suptle so it picks up.
thanks
On Tue, Apr 28, 2009 at 1:56 PM, Anne Robson <anne.robson@xxxxxxxxx> wrote:
> 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@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:
