Finding characters within a text
How to check, using single formula, that a text within a certain cell
contains one of certain characters? For instance, how to check if there is a
'R', 'L' or 'Ps' character within cell A1 that reads 'W-RII'.
Thanks in advance
Hmm..not very elegant, but maybe
Returns TRUE if the text in A1 contains 'R', 'L' or 'Ps' .
FIND is case-sensitive, use SEARCH if you also want to find lower-case
Joerg Mochiku...Need Formula To Find Blank and NonBlank Cells
I have a worksheet with 6 columns (by Month)
Sep Aug Jul Jun May Apr
I have to review starting for example with May, I need to find any cell in
May range that is null <> where Jun and Apr both are not null <>
So if May is null and Jun and Apr are not null than I would count that as 1.
If May is null and either Jun or Apr are null then I would not count them.
"hilltop55" <firstname.lastname@example.org> wrote in message
news:08D989CB-D1B4-49F...Sql to find record in a hierarchical chain
Hi, lets say I have a table with 2 fields:
Field 1 - ref
Field 2 - parentRef
Now in the structure there could be numerous chains until you get to
the top of the hieratchy (where the ref field = parentRef field).
so in this 444 is top of the chain (there will be many other records
as well that are nothing to with 444 and are part of their own
hierarchy). So how do I easily relate 111 to 444. Ie how do i find
the ultimate top parent for a given 'ref' field.
Hope anyone can give me some pointers ...what is the function and name is of the symbol in each table cell.
Under Paragraph I clicked the Show/Hide Symbol icon so I can now see a
symbol at the end of each text within a table cell.
I wondered what that is so I tried to use Help to find out.
I did find help that mapped a word (like paragraph) into a symbol.
But I can't find anywhere where if I know the symbol it will tell me the
Can you tell me how to find such info?
Or maybe you can tell me what the function and name is of the symbol in each
I'm sorry, I meant to sent this to the Word group.
Of course, I wouldn't mind getting the info...Summing in A Query
I have a database which fuel records are stored in. The data is
stored in two tables. The first records the daily logs that operators
use each time they fuel up. It stores their name, the key they used
(keylock fuel system - it's ancient) the unit number of the equipment
using the fuel, and the amount of fuel they took. The second table
stores the month end information retrieved from the key lock print
out. It keeps a running total of the amount of fuel taken with each
key, and the operator using that key.
We have problems making sure all of the fuel is accounted for each
Is it possible to write a criteria where the value of an empty field is "0.00"?
Background: I have three queries with different customer account groups. Not
every salesperson has customer accounts in every accountgroup - so, he will
not shown up in that query. But he has accounts included in another query.
Now, I would like to get a sum of commission earned by each salesman
calculated from all three queries together.
Since the salesman has no record in one query the total sum of that specific
salesman is not shown.
Any idea how to solve that problem?
On Wed, 29 A...Finding all queries which use a table
Does anyone know of a tool that can scan all queries in a database and find
if a certain table is used? I have a table called tblCustomerRollup which is
old and outdated. I want to see which of the 500 queries in my database use
this table without opeing every single one of them?
Sounds like a variation on Search/Replace. Try searching online for
"Database Documenter" as a starting point.
A couple of the commercial tools I've used include FMS, Inc.'s Total Access
Analyzer and Black Moshannon's Speed Ferret. There are a lot of fr...Where do I find SSADM 4+ templates in Visio ?
Hi, I understand SSADM 4+ templates were available in Visio 2002. I have just
moved from Smartdraw to Visio Professional 2003 and am having difficulty
finding SSADM 4+ templates.
Does anyone know where I can find these templates? Are they still available
in the 2002 version?
...need custom cut and paste functions
I once wrote here about a problem I had cutting and pasting where columns
would turn to "REF!" after a cut and paste. I would work around it by
copying, pasting and then manually deleting instead. I thought turning
everything in the sheet to absolute references would solve the problem but
it didn't so now I am thinking of a different solution.
Could someone tell me what I need to do to write my own cut and paste
functions which would basically copy the selection and then on a paste it
would paste and then delete the original selection from where it was copied
from...Function doesn't run
In my spreadsheet, I have the following function
=VLookup(K16, zips, 2)
However, instead of returning a result, the function remains in the
cell. How do I fix this problem?
Format the cell as General and re-enter the formula (F2, ENTER)
Microsoft MVP - Excel
"Justin" <email@example.com> wrote in message news:firstname.lastname@example.org...
| In my spreadsheet, I have the following function
| =VLookup(K16, zips, 2)
| However, instead of returning a result, the function remains in the
| cell. How do I fix th...email address on Service Call Entry window
Add an email address field to the Service Call Entry window for the customer
contact on the service call. Even if it is not pulled from the email address
of the address id on the service call, at least the dispatcher could enter an
email address on the service call in order to communicate with the customer
regarding the call. It is common to take email address as part of contact
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the m...XL 2007: How to find out what keyboard shortcuts I've assigned to macros?
Over the years, I've recorded and written a lot of macros. (Probably
time to take a week or two and go over them and delete at least
half!) I assigned a keyboard shortcut to a lot of them.
I seem to remember that before XL 2007, there was a keyboard organizer
that I could go through and review what shortcuts I had already
assigned to my macros. I can't find that in 2007, though.
Is there an easy way to generate a list of all my keyboard assignments
and what macros they go to?
I don't recall ever seeing any such keyboard organizer in 2007.
Canned from a prev...Simple Access counting queries
Hi, hoping someone can help a relative newbie with a pretty simple
query. My database (Access 2007) has three tables:
Purchases (many-to-one links to both of the other tables, this is
basically a linking table)
I have two simple queries I'd like to get out of this database, but
I'm a bit stuck on how to construct the SQL. Any direction you can
give me would be helpful.
1. List of all customers who have purchased 2 or more products (or 3
or more products, or 4+, etc.)
2. List of all customers who have purchased both Product A and Product
B (or A, B, and C, or B an...Query to hide duplicate records
I recall that this used to easy in previous versions (Unique values
only ??), but in 2007, I can't get this to work at all.
I have a table with our companie's job numbers in it. The job numbers
show up multiple times because of different phases of the project:
3077 Univ. of Vermont/UC/LEED
3077 Univ. of Vermont/University Commons: Building Fee
3077 Univ. of Vermont/University Commons: Excess Professiona...
I need to jut have a single listing of each project number, otherwise, I
get repeated records in the query that looks at this information (which ...RPC over HTTP/S on Exchange 2003
I have been configuring my single server with exchange to use RPC over
I have followed the instructions in MS guide and another simplified
Server spec is: Server 2003 standard SP1, Exchange 2003 SP1, XP client
SP2 with outlook 2003 sp2
The bottom line is that when testing from the WAN, the outlook client
will not connect and say that the exchange server is unavailable.
I have a lot of experience configuring rpc over http/s with sbs2003 but
this is the first time for server 2003 standard.
I have outlook ...How to create an "and" rule in Query Based Distribution Groups
With Exchange 2003 Query Based Distribution groups, is it possible to create
an "and" rule? ie, all users who are based in "London" "and" have the first
Please reply to news group only. Thank you.
"Curtis Fray" <email@example.com> wrote in message
news:OjVc...Problem with vba code to export query result in excel
I have a access report that exports to excel with click of a button after
choosing parameters. This works well. However I have to modify couple of
fields to utilize formula in the export module. I am not sure how to do this.
I am writing the above code which seems to cause problem. I appreciate any
help to resolve this issue. Thanks.
If lngColumn = 12 Then
xlc.Offset(0, lngColumn).Value = =([UnitPrice]*[OriginalShippedQty])/1000
It seems the fields UnitPrice and OrigianalShippedQty are not being
>I have a acces...Adding a button with a function on protected sheets.
How do i add a button to 'reset/clear' the data on a worksheet that is
protected and uses VLookup data (from another worksheet).
Everyday this table will have data chosen from combo boxes or manually
entered in allowable editable fields and at the end of the day after the
files is saved, I need to clear that data for use on the next day.
How is this Reset button applied with allowable edit ranges, VLookup data
and a protected worksheet?
There's several ways to do this.
1. Instead of straight vlookups, use
=IF(ISBLANK(VLOOKUP(....)),"",VLOOKUP(....)) wher...Find and replace with bold in cells
I have a VB6 program that is executing Excel 2007, opening a worksheet, and
extracting some of the cells to write data to a text file. Some of the cells
contain bold text on some (not necessarily all) of the text in the cell. I
would like to do a find and replace on the bold tagging to replace it with
something like "<b>" at the start of it and "</b>" at the end of it. How do I
set this up in VB6? Thanks!
The following function will return a string including <b> and </b>
tags from the text of cell R.
Function BoldMarkup(R As Range) As...Formula to find last monday (tue, wedn, thu or friday) for a given month
I need a formula to calculate the date of the last monday, tuesday,
wednesday, thursday or friday of a given month.
Can't seem to find the answer anywhere.
day: wednesday (or corresponding nr)
Who can help?
Thank you for reading and eventually answering my question.Back
Microsoft MVP - Excel
"Michele" <firstname.lastname@example.org> wrote in message
> I need a...Today Function
how is this function called in the code?
I want to use in in an update query that is coded to a button.
I hope I'm understanding what your asking for but I think this is what you
are looking for:
>how is this function called in the code?
>I want to use in in an update query that is coded to a button.
Message posted via AccessMonster.com
Well I think it is either
not sure which and not sure how to use it in the code.
I ...how can I asign printscreen to a function key or key combination?
My key board has no printscreen key. What can I do?
That seems unlikely, but it is hardly a Word issue. The PrtScn button is
usually a dual function button somewhere on the top row of your keyboard. If
it is not then you need to ask the keyboard manufacturer.
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP
My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< ...I can't find outlook express on my Mac?
I found a folder called Outlook express, but there is no actual program. I
have Internet Explorer, should't I also have Outlook Express?
what version of IE is installed?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messa...Difficult query
I have a table called WT,contains the fields "Type of call","DateW" and
"ID", this table is used to by users to add rows that determine type of calls
received in a call center,I want to create a query with the following
1- To view number of calls received in each type per day.
2- To show the field "Type of call" in this query,even the type that wa not
used,and to view number 0 in the count field.
3-Prcentage of each type of call .
On Dec 11, 3:52 pm, Pietro <Pie...@discussions.microsoft.com> wrote:
> I have a tabl...Report Query in RMS
Is there somewhere that I could get some information as to how the reports
in RMS are composed.
When you look at the various reports they all seem fairly simple in there
Are the any examples of how these reports are composed. The //---
Columns ---// iformation seems to be the same in most reports, same as the
//--- Title Rows ---//.
Setting up the flitters and the TablesQueried I need to understand.
I have the schema for 1.2.
How do I better understand the following or what do I need to learn. I wish
I was in college again and had all the time in the world.