Counting the number of fields in a column that have data?
I have an Excel document with about 5,300 rows. One of the columns has
data entered only into some of the fields, maybe 100 of the 5,300 rows.
Is there an easy way to get Excel to count all of the fields in that
column that have data entered in it?
On 1/25/10 4:57 PM, in article eW3gilgnKHA.1548@TK2MSFTNGP02.phx.gbl, "Rick"
> I have an Excel document with about 5,300 rows. One of the columns has
> data entered only into some of the fields, maybe 100 of the 5,300 rows.
> Is there an easy way to get Excel to cou...Pivot table calculated field: multiply Sum of FieldA with Max of FieldB
My question concerns Excel 2003.
A user asked me about a calculated field in a pivot table.
Some of the fields are DT_NOW, GW_WCR, GW_LOB.
The formula of the calculated field should depend on the date
Up to 30/06/2009: Rotation = GW_WCR / GW_LOB * 91
Starting 01/07/2009: Rotation = GW_WCR / GW_LOB * 28
She added a field to the underlying data called ROT_FACTOR, filled
with 91 until 30th june and filled with 28 starting 1st july.
The current formula is
The cutoff value 300000 is an arbitrary value base...Hidden fields in new emails
When I begin to type a new message, the text doesn't appear (the words are
hidden) until spell check/sending/or printing. When I select the icon for
the font color of text (black) it begins to show my typing as I'm composing
the message, but the other words (anything I typed in the 'hidden field')
only shows up in the spell check portion and remains hidden. Why are my
messages starting with this hidden field and how do I get rid of it? I'm
sure I must have pressed some command inadvertently as it was not always
working like this. (only been using about a week so s...Olk2003 + win7/64 : no delivery status notifications received
I am using Outlook 2003+Windows7 (64 bits) for my emails from MSExchange
When i send message inside organisation (or outside) I never receive status
I have checked and recheck all my settings.
I made some tests with WinXP : status notifications are sent.
The two outlook have the same settings.
Why this difference ?
Thank in advande.
...eliminate spaces after a text field
I am designing in query and there are spaces after text field. How do I
delete the spaces after? Thanks
Try something like:
To remove trailing spaces only (not leading spaces):
Spaces in the middle of the field will not be affected.
Use your actual field name in place of YourField. Use whatever you like in
place of NewField.
"Cam" <Cam@discussions.microsoft.com> wrote in message
> I am designing in query and there are spaces ...How to select query fields based on Combo box?
I have a table which has 5 fields, ID, Name, Age, School and Class. I have a
combo box which shows the fields of a Query. This combo is located in form
which presents all the fields of the table. What I want to do is once the
user selects a field for more than one the fields in form shown as selected.
Also, I want to make a button for reshow all fields in form.
Thank you in advance.
...Can receive e-mails but cannot send any....
I have everything set up for my e-mails to get sent in from my AIM account
but when i go to send an e-mail this is what i get
Account: 'Windows Mail', Server: 'pop.aim.com', Protocol: POP3, Server
Response: '-ERR invalid command', Port: 110, Secure(SSL): No, Server Error:
0x800CCC90, Error Number: 0x800CCC18
Please, Please, Please help me. I'm trying to respond to an ad on craiglist.
That's not a send error, it is a receive error.
'Invalid command' in this case probably means you tried to use an option
that the server does not support.
...Not Receiving IMAP
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: imap
This question was posted and unanswered back in March - I have had this same problem on and off for months now and it has reared up again with no changes to the system to have caused this? <br><br>My INBOX doesn't register new emails that I receive, despite 'Send & Receive' either on schedule (9 minutes) or manually <br><br>I can see (in the bottom right) that these checks are running and that the mails incoming on the server are trying to download...Filter custom lookup field according to another field on form
Customising the form for a "Case".
In the "Overview" section of the "General" tab there is a "Customer"
field which corresponds to the "Account" or "Customer" (company, if
you like) associated with the Case.
I have added a "Contact" attribute as a Lookup which will associate
the "Case" with a particular "Contact" belonging to the
"Customer"/"Account" (by creating a relationship in the "Contact"
entity, which is then exposed as an attribute in the "Case" form).
How...Sent Mail Missing
On my wife's new Acer Laptop (Aspire 5517, Windows 7 Home Premium Version,
6.1.7600 Build 7600, x64-based PC, 3 GB of RAM, all WU's current, McAfee,
Spyware Doctor with AV, MBAM, SAS, CCleaner), I just set up her WLM account
(works fine), plus I added my WLM account to her computer.
I can read my WL mail just fine (inbox, contacts, etc.) and can send
messages ok too, except that my `sent' messages' are gone. On my Vista HP
desktop I've got 60 messages in my `Sent' folder but on my wife's Acer
Laptop there's 0 messages in my sent folder.
My wife ...Showing a date field as a number
I was wondering if there was any way that I could have a column showing the
date and time (20/12/2007 06:00:00) and another column show the date and time
as a number, (29548). This would be done in a select query, but I am not
Is it possible?
for 20/12/2007 06:00:00
#.0000 (with Decimal Places = to suit your needs)
# (with Decimal Places = 0)
Microsoft Access MVP
http://home.comcast.net/~cccs...Combining multiple records into one memo field
What I want to do seems simple enough, but I can't seem to find a simple
answer. go figure.
I have a table that has records of different leinholders. I want to take the
leinholder names based off of certian criteria and combine them into one memo
Doe Jane, Doe John
This has nothing to do with database structure. I need to utilize as much
space on a report page as possible. I first though of using columns in the
detail section of the report, but the leinholder names can get qiute lengthy
and fields cannot gro...Creating Form, Need 1st 2 lines of field to indent, 3rd to wrap
I'm creating a form for myself to enter into. I have lines that are
formatted in what they call "Indented Block" - I have a heading on the left
margin, which I don't touch when filling in the form, the field starting at
an indent of 3", the 2nd line of the field if it's long enough to wrap to
also be at 3" and any lines after that to wrap back to the left margin.
Kinda like this:
2nd line of field
3rd line of field continued
BUT, I need to be able to indent the 3rd line also to 3" if it's too short &...Field not displaying contents on basic query
I have a customised entry for a "service". The "service type" field is a
picklist. When I run a query that includes the "service type", the result is
a set of records that have a blank where I would expect one of the picklist
items to be.
If I click on any of the records, they open in a new window and the complete
details for the "service type" are there.
Can anyone shed any light on what I am doing wrong here?
I don't think it's anything you're doing wrong - rather it's the
customisation. The service entity is not a customisabl...Hyperlink field in a subform
If I try to drag and drop (any type of file from a windows explorer window)
into a hyperlink field on a form - it works. When that same form is a
subform within another form the drag and drop does not work. Any ideas? My
users prefer to use drag and drop to having to browse to the folder where the
files reside that they want to use to set hyperlink....
...Want to use Excel as a database for small school, how to print out specific fields??
I am a volunteer parent for a small school and have been asked to help
setup a database of the students (160) and need to figure out how to
create a file and print just specific fields for different purposes.
I tried the mail merge but didn't get the result I needed, which is
just a page of information to pass out amongst the different families.
I've looked around but can't find anything that looks like it would do
what I need, but I seem to remember that it is possible. so far I've
got my column headers and the data entered, but can't do anything with
The ...Outlook 2003 Sent item problem
My problem is I can send a new message, it goes to the
outbox, it is not assigned a date, when send recieve is
carried out it does not go. If I forward this same
message it transmits properly.
What are your send/receive settings for this account?
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 searching google.groups.com and finding no answer, Greg D asked:
| My problem is I can send a new message, it goes to the...Outlook quits sending and receiving
We are on a peer to peer network and one of the computers
on the network seems to have a problem with Outlook 2000
where he'll be able to send and receive mail and then all
of a sudden 3 or 4 times a day you get the message that it
can't send the mail and the only way to resolve it is to
log off the computer and then log back on or to reboot the
We have reinstalled outlook a few times and have done all
the updates that are out there as of today.
Any idea what causes this problem. We are all using
Windows 2000 professional as our operating system.
...How do I lock a .pub doc so only certain fields may be edited?
I have created brochures for employees that I ONLY want certain information
to be editable. For instance, they can input their name, contact info, photo
but not be able to change the main body copy, headline, etc.
How do I lock down certain pieces of the brochure but not others?
Are they going to be working on the design of the brochure or are you =
trying to create a form?
If it's a form...output to Acrobat and create a pdf, then make it a =
If you're trying to lock aspects of the design process...dunno if that =
can be done. One of the gurus will have to address ...On dismount/mounting store, Undeliverable messages are sent
I have been having this problem when a dismount/mount my store on 2003
If we had messages that came back as Undeliverable from System
Administrator, the mailbox that sent the original message gets the
message of Undeliverable when I re-mount the store.
In fact, we have even had the instance where the recepients of the
original e-mail get the Undeliverable message a month or so later when
Has anyone seen a similar issue?
I've seen something similar after a virus issue in which I was
receiving cases from users who reported messages that were yea...Pocket PC deletes From field
I've had this problem a lot and it's been happening a lot
lately: Whenever I have to restore from a backup on my
pocket pc, and then sync to Outlook XP, the From field on
all of the messages they both shared goes blank. When I
click on the message, the From information is still there,
but it wont show me it in the browsing panel. Kind of
annoying, and I can't find any way of stopping it or a fix.
Thanks for any suggestions,
...Can not receive Email.. Need Help
Earlier this morning, my exchange server 2007 (hosted on SBS 2008) just
stopped receiving external e-mail. We can send interoffice e-mails and we can
send out e-mails to other locations fine, but we are unable to receive any
e-mail. All internet connections are normal as well, and the port 25 is open
on the firewall.
The error from when we try to send an e-mail to the server is this:
“This is an automatically generated Delivery Status Notification. Delivery
to the following recipients failed.”
Earlier today I installed the anti-spam update from MS “Microsoft excha...Automatically updating fields
Sorry to repost this but I just want to check whether there are any
new options for what I want to do:
I have several thousand records in MS CRM (leads and accounts), which
contain fields like annual turnover, number of employees etc. In 12
months time the information in such fields will be out of date and I
need to be able to up date these fields from an external source so
that we can continually target our marketing activity based on fields
like turnover, number of employees etc.
Responses to my original post gave the following options:
1. Scribe Insight
2. Write SDK Calls
3. Update t...i have fields that are formatted for text that randomly convert t.
i have fields that in the original spreadsheets are formatted as "text" that
appear as date when ultimately converted to a .csv. This happens purely
randomly and all the sheets and fields in which they appear have been
formatted as "text". In spite of this certain numbers appear as "date"
formatted in the csv file. any ideas.
The CSV don't change any formatting, it's when you import it into Excel it
changes, you can rename the file to a TXT extension, open it from file>open
and the text import wizard will open, if you click next twic...Send/Receive doesn't work until changing folders.
An Outlook 2000 client on WinXP w/ an Exchange 5.5 email
server, new mail does not arrive in the inbox until the
folder is changed, like from inbox to deleted items. Then
all the new Email messages come into the inbox. Clicking
on Send/Receive also retreives them. I though new
messages automaticall go to the inbox on Exchange.