[mso] Re: Ms access query query

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).
http://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: