comparing data in two fields
I am having difficulty creating a T-SQL script that displays records from a
table, where data among those records match for one field but do not match
for another field.
I am starting off with the following script:
select * from SOP30200 where SOPTYPE = '3'
I want to show records where the field "MSTRNUMB" is the same but the field
"SOPNUMBE" is different.
Is this what you were thinking...
FROM SOP30200 t1
INNER JOIN sop...How to get a lighter shade of grey for fill color?
In Word, I can get any shade of grey I want using a percentage. In
Excel (2000), I can only seem to use the 5-6 values in the fill table.
The lightest one is too dark for my purposes. Is there any way to
bring up the fill table that is used in Word?
Running Excel 2000 SP-3 on Windows 2000
Goto tools>options>color Tab. Select the color you do not like and select
"Modify". Choose the color you do like and it will replace the color you do
not like. Ok out.
> In Word, I can get any shade of grey I want using a...using COUNTA on a field that has been filtered
What is the function to count entries on a column that
has been filtered. COUNTA will still count the hidden
fields, rather than just the shown fields
Take a look at the SUBTOTAL function in help.
"firstname.lastname@example.org" <email@example.com> wrote in
> What is the function to count entries on a column that
> has been filtered. COUNTA will still count the hidden
> fields, rather than just the shown fields
...@ symbol in field
I need to have some cells with a @ character at the start of them. As soon
as I add it and move out of the cells it gives me a "function not valid"
error. I have tried turning off all sorts of autocorrect and other options
to no avail. How can I get that to stop trying to change it and leave it be?
For example I want the cell to say @image
Format the cell as text and you will be able to input it.
Pleased hit Yes if my comment has helped.
> Excel 2007.
> I need to have some cells with a @ character at ...Greyed out printer Icon
I have a WinXP Pro machine with Outlook 2002 (Office XP)
installed. My printer icon along with some other icons
appear greyed out. However, if I open the email (double
click it) then I can print it just fine.
I tried uninstalling and reinstalling Outlook. Any idea?
Thanks in advance.
In article <firstname.lastname@example.org>, shantanu.mondal@compass-
> I have a WinXP Pro machine with Outlook 2002 (Office XP)
> installed. My printer icon along with some other icons
> appear greyed out. However, if I open the...Grey Menus
I'm using a trial version of Microsoft Visio 2007 Profesional, and I was able
to open a file that was emailed to me, but when I try to modify it almost all
of the menu options are grey, so I can only print, preview and open a new
stencil. I can't even save the file. Is it because I'm using a trial version?
Maybe this is a silly question, but it's my first time using the program.
Thank you in advance!
In article <FDA4D87D-E912-465D-BE41-7E83F27800BC@microsoft.com>, =?Utf-8?B?
> I'm using a trial version of Microsoft Visio 2007 Profesional, a...Extra field in Payables
A Client would like a field in PM Trx Entry similiar to invoice number that
would watch for duplicates.
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 message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
I have created two custom attributes in Contact, published the customizations, created an email template and inserted them in the body. Created a workflow rule to send an email.
Mail sends ok, but the custom fields ate not instantiated (they are empty). Standard attributes are ok..
Please give me some help. I published aggain... nothing happens
...corrupted memo field in multi-table query
I have a multi-table query in Access 2003. Several of the tables have memo
fields. When I run the query, the memo fields are displayed as Asian
characters or a symbol of a square. There is one expression that concatenates
first and last name and a parameter on another field. It is only the memo
fields that display these characters. I tried compacting and repairing the
database, but that did not help. Text fields with the same text as the memo
fields display fine. I've tried creating a similar query as a test but I
don't see this error. What might have corrupted this query...Catalog Merge fields come as Plain Text, but datasource is Rich Te
In creating a Publisher Catalog Merge template, I have an MS Access 2007
database, with a product decription field that is a Memo field, with Rich
When I import the field into the Catalog Merge Template the field comes over
as Plain Text. The formatting information shows a HTML Tags.
Example : "Product Description" shows the quote marks as
Any ideas? I can't see any format options in Publisher 2007 to allow me to
keep the RTF format.
I suggest you create a new publication from the catalog merge and save that
result as a ...Convert a field to not allow Nulls
How do you do that? I want to require the SIC field to be mandatory. Possible?
If you go into Schema manager, you can change the settings for a field
to be required. You will then need to publish the change and issue a
On 22 Jan 2004 07:49:46 -0800, email@example.com (KBLawson) wrote:
>How do you do that? I want to require the SIC field to be mandatory. Possible?
As the CRM admin go into CRM.
Click on Home-Settings-System Customization-Accounts-Customize Form. You
then need to add the SIC field. Once done you can then go to the properties
for this field and click the S...Cells (some) being Greyed In: How To Remove Grey ?
Using Excel 97.
Some of the cells, but not all, are greyed in (cell background, I guess
you'd term it).
Don't know how it happened, but don't want it this way.
How can I get all the cells to have the normal white background (with black
Right mouse click cells that are affected and go to format cells and
patterns tab and click "no colour" has other options there for font
> Using Excel 97.
> Some of the cells, but not all, are greyed in (cell background, I guess
> you'd ...Selectively Update Field in Table
I need to selectively update a field in my master table with new data. By
selective I mean only records that meet a particular criteria need to be
updated. My new data is in a different table, and they are related by repair
order. This is the SQL code that Access generates:
UPDATE RepairData LEFT JOIN DallasData ON RepairData.[Repair Order] =
DallasData.[Repair Order] SET RepairData.[Material Out] =
I know there are approx 75k records that need to be updated, but when I go
to run this query Access ...Properties Greyed Out
In a lot of my Excel sheets when I open them and go to
the File menu, the properties button is greyed out. Any
idea why? Some of these sheets have macros and some of
them don't. Other Excel files are fine.
are those workbooks protected
Message posted from http://www.ExcelForum.com
Yes, I figured it out just after I posted. Thanks.
The reason I am asking is that Indexing Service does
index the properties correctly when a workbook is
protected. That's my real issue...
When a result set comes back, it inserts "no title" in
the result set o...Logical tests between Word form text fields
I have a Drop-Down form field with "Yes" and "No". I want to place the value
4 in a Text form field in the same document if the user selects "Yes" in the
Drop-Down field. I set the Text form field to type "Calculation" but can not
figure out the formula to use that doesn't return a Syntax error or
"Undefined Bookmark, Yes". While I have Word 2007, I need to create this
form for users with 2003 and so am using Legacy form fields.
Instead of using a calculation formfield, I'd suggest an ordinary formula field,...Auto-populating date field
I have a date field that I would like autopopulated on the loading of the
form. Its just a one time population of the current date it was created. We
still need the ability for the users to modify the value, so its just a one
How I do to validate one field with condicional function? I am doing it.
Made one matrix call Brand and others call Model_A, Model_B, Model_C...
n Brand I put, for example, ADC, Belden, Sony, Toshiba ...
In the others, for example Model_ADC, I put the all models reference the ADC
Brand, and I repeat this operation for next matrix.
Now I create one cell with validade Brand with suspense list. It is OK.
After I create one cell with condicional validade. It is Ok.
=SE(E15="...Auto-Recommend Names in To: field
When I'm typing addressees in an Outlook message, it will recommend one or
more names after the first few letters. For example, if I type in "and" it
will recommend "anderson, sven" and "andrews, della" which is great.
The problem, one person I used to email frequently has left and is no longer
in the global address list on exchange. However, when I start typing in the
last name (which is similar to another employee) that person's name pops up
in the list.
Where are those entries stored, and how can I edit it to delete that
entry... I have searched hig...Adding a field to a form...
I would like to add a field to a form. The field is not part of an
auto-linked table so modifier i not the solution. However it is a linked
The scenario is this... I would like to add the current cost and tracking
optin to the ATP (available to promise) screen.
I beg to differ. Depending on the version of GP you are using, you can use
simple Modifier and VBA to retrieve this information by adding your field to
the window, then using either RetrieveGlobals (v8), RetrieveGlobals9 (v9), or
the UserInfo object (v10) to open an ADO connection to the company database.
...What tables and fields should I use?
I am looking for database design help with my tables and fields.
I have 75 questions, but I will continue to add more. I plan on giving at
least 100 answers to each question. As a result I want to be able to keep a
record of all the answers I give for a particular question.
How many tables would you recommend I use? and what fields should be in each
Have a look at...
"I feel I have been denied critical, need to know, information!" - Tremors
http://www.r...Actions "greyed out"
Just installed Outlook 2003 (Trail Version) and it does not let me complete
any actions (e.g., set up an appointment, accept an invitation). Appreciate
Did you activate it? How long ago did you install the trial?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all mail sent to my personal
account will be deleted without reading.
After furious head scratching, txtxyeha asked:
| Just installed Outlook 2003 (Trail Version) and it does not let me
| complete any actions (e.g.,...Why this VBA does not work for some fields while it does for the o
I want to make the default of the confirmation is No in the YesNo key,
because the tendency of people is just to hit enter while their purpose maybe
not to corrent. but
this VBA works for Exp Class field in my form, while it does not work for
Inovice Amount. Is that because of the type of the field si fifferent?, What
should I do.
I appceciate for any idea provided.
Private Sub ExpClass_BeforeUpdate(Cancel As Integer)
If Not IsNull(Me.[ExpClass].OldValue) Then
If Me.[ExpClass] <> Me.[ExpClass].OldValue Then
If MsgBox("Anda telah merobah!!, a...Removing a character in a field
I have a table which contains an asterisk marks in some of the fields in
some records. What would be the easiest way to get rid of them? Wherever
there are asterisk, I need them to be Null fields. I tried with Find and
replace with "" mark, but it doesnt seem to work. Am I missign something?
On Wed, 20 Jun 2007 07:46:59 +0530, "Ramesh" <ramesh2020@gmaildotcom> wrote:
>I have a table which contains an asterisk marks in some of the fields in
>some records. What would be the easiest way to get rid of them? Wherever
>th...PivotChart Data Field
I have a data set of nodes that generated error codes at different times. I
want to plot the data with a separate series for each error code, with time
on the x-axis and node on the y-axis. I want to use a PivotChart so I can
select to show only certain error codes or nodes of interest. I am having
trouble setting up the PivotChart (Excel2000). I can't do it as a scatter
plot (not allowed for PivotCharts), so I chose Line with Markers. The
problem is the data field - the available options are like Sum, Count,
Average, etc. but I want it to be Value, as in the value of the node....grey autotext on custom toolbar
From Word doc, I created custom toolbar with menu, autotext and email button.
Email button opens msg in Outlook 2003 but autotext selections in menu are
greyout. What to do??
are you using word as your email editor? Are you clicking in the message
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 2007: http://www.slipstick.com/outlook/ol2007/
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Soluti...