[mso] Re: Ms access query query
- From: Cathy.Evans@xxxxxxxxx
- To: mso@xxxxxxxxxxxxx
- Date: Tue, 28 Apr 2009 15:50:27 -0400
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
*************************************************************
Other related posts:
