[mso] Re: Ms access query query
- From: Anne Robson <anne.robson@xxxxxxxxx>
- To: mso@xxxxxxxxxxxxx
- Date: Thu, 30 Apr 2009 11:07:05 +0100
As many MSO listers know I loathe Access <grin>! If you take out the date
ranges does it bring up the dundee results then? Could this simply be that
you have no dundee results for those dates!
2009/4/28 <Cathy.Evans@xxxxxxxxx>
> When you say like "Dundee", is that your criteria, or do you have
> wildcards, *dundee*. To my knowledge, access is not case sensitive, so
> the case shouldn't matter. Is it the office name itself that is the
> problem, or if you are filtering between start/end dates, is there
> something about the date on that particular record that is different? Are
> you using any global functions that might inadvertently negate what your
> queries are doing? One time I created an export to excel and couldn't
> understand why it kept stripping my leading zero's even when I formatted
> it correctly, but then a colleague asked me if I might, by chance, have
> any find and replace code in my routine, and sure enough, I did have some
> find/replace code that ended the routine, and I was inadvertently
> replacing the data I'd just sent because I had my excel range named
> wrong!! Does this data come on a regular basis from excel or was it just
> a one time import to get the data and then it's used in access? Thanks.
>
>
>
> Rachel Jobes <racheljobes@xxxxxxxxx>
> Sent by: mso-bounce@xxxxxxxxxxxxx
> 04/28/2009 02:40 PM
> Please respond to mso
>
> To
> mso@xxxxxxxxxxxxx
> cc
>
> Subject
> [mso] Re: Ms access query query
>
>
>
>
>
> 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
>
>
>
>
>
>
> ------------------------------------------------------------
> The information transmitted is intended only for the person
> or entity to which it is addressed and may contain
> proprietary, business-confidential and/or privileged material.
> If you are not the intended recipient of this message you are
> hereby notified that any use, review, retransmission, dissemination,
> distribution, reproduction or any action taken in reliance upon
> this message is prohibited. If you received this in error, please
> contact the sender and delete the material from any computer.
>
> Any views expressed in this message are those of the individual
> sender and may not necessarily reflect the views of the company.
> ------------------------------------------------------------
>
>
> *************************************************************
> 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:
