If Statements #12
I have 2 cells with asterics in them, D11 and I11. I am trying to write a
forumla using if statement
How could I combine both cells to add them if they both have *?
In article <B8BDDA8A-EA00-475E-9427-6E06540EC5BC@microsoft.com>,
"anat" <firstname.lastname@example.org> wrote:
> I have 2 cells with asterics in them, D11 and I11. I am trying to write a
> forumla using if statement
> How could I c...Text Color using IF Statement
Does anyone know if it is possible to change the text color when usin
an IF statement? Example: IF (C<4, "Pass","Fail") results in "Pass
for values less than 4, but if the value is greater than 4 I want th
word "Fail" tp appear in red.
Currently I am using Excel 97
Thanks for the hel
Message posted from http://www.ExcelForum.com
not possible with a formula but have a look at 'Format - Conditional
Frankfurt, G...Does an if statement calculate both the true and false?
I have a spreasheet, with 40000+ rows.
I have an if statement which is basically if(A1="OK",0,long and complex
Almost all instances are "OK" with a few exceptions requiring the complex,
time consuming part of the formula.
Does excel calculate that part of the formula even for cells which are "OK"
and hence taking up loads of time, or does it ignore it knowing it doesn't
need to return it?
VBA evaluates both parts of the formula, the Excel worksheet IF function
only evaluates one part of the formula depending on...Version control for SQL Server databases
It is my understanding that version control for sql server databases
can be problematic. I have been thinking about this problem on and off
for a while, and over the last couple of hours the beginnings of a
system have crystallized. I am going to sketch the first draft of this
evolving idea below. If anyone recognizes the mechanisms as already
existing in some product or solution, please let me know. If anyone
recognizes problems or limitations of the system, please let me know
about those too.
Once again, this is just a first draft that I have been brainstorming
for about 2 hours, ...Is it possible to find which sql statement is running?
I have a sql batch:
select .... from ......
insert into ....
select something else....
Each step takes a long time to run. Is it possible to check which statement
the SS is running at a moment?
...Unable to insert Access queries
When trying to use ms-query to import data from an Access database, I've found that it doesn't allow me to open some of the queries (views) from access. It seems that the queries I have trouble importing have the nz() function in calculated fields of the access queries (views) (or in a sub-query). Is this simply not supported or is there a way to work around it?
In the Access query, instead of Nz, use an IIF formula. For example:
Craig A wrote:
> When trying to use ms-query to import data from an Access database, I've found that...RMS Statements
How do you get the current date to print on a statement?
...Convert Access Database to Excel?
I am a very new Access/Excel user. Is it possible to convert an Access
database to Excel? Thank you
Somewhat. At the core of Access, there are tables which are easily
transferrable to Excel. Limitations are that Access can store MANY more
records/rows than Excel (pre-2007) can hold. To check, open up the Access
tables, and see how many records there are. (note that its from here you can
easily select all data, copy, and paste into XL)
Typically, Access is used when dealing with large amount of records, or if
you need lots of interactions/relations between the tables. But, wit...Qry-Statements
I want my report to show if my product is (specked) or (non-specked)
In the query i am able to get only one of them to show up. I have tried use
OR, and AND. They still only show one. I have created two drop down's on the
form and have tried combinding them and that does not work.
Can anyone help.
We aren't there. We can't see what you are looking at. We have no idea
what data you are storing in your tables, nor how you are querying them.
More info, please!
Microsoft Office/Access MVP
"Lisa" <Lisa@discussions.microsoft.co...Converting Access97 Database to Access2002
When I try to Convert my Access97 files that are on 3 1/2"
floppy diskettes, I get Error 3799. "Could not find
field 'Description'". Why does this happen? How can I
get these files converted?
Be sure to copy the files to the hard disk before attempting to convert
On Sun, 5 Oct 2003 22:04:45 -0700, "Peglynne" <email@example.com> wrote:
>When I try to Convert my Access97 files that are on 3 1/2"
>floppy diskettes, I get Error 3799. "Could not find
>field 'Description'". Why does this happen? How can I
>...Database design decision: contact information
I need some advice with a design decision. Customer wants to track people,
along with various means of contacting them.
The easiest way is to have the fields CellNumber1, CellNumber2, EMail1,
EMail2, FaxNumber built into tblPeople.
An alternative is to have tblPeople linked to tblContactInfo which is linked
to tblContactMethods, thus providing "n" number of contact methods and the
Am I making more work for myself by using the latter approach?
On Sat, 09 Feb 2008 16:46:53 GMT, "Larry Kahm"
<lkahm@nospam_heliotropicsystems.com>...Access 2007 database on Windows Vista and Windows 7
I created a database using Access 2007. I am going to distribute it as a
runtime application using the Access 2007 runtime engine. The problem is
that engine is only supported up to Windows XP SP2. What do I need in order
for my database to run on PC's with Windows Vista and Windows 7? Is there a
version of the runtime engine that will work with those operating systems?
Access 2007 runtime works on XP (SP2 or SP3), Vista and Windows 7 (I
I think Microsoft just didn't update the web page to indicate that it works
on Windows 7 (maybe it's not officially t...how do I insert an endnote in publisher
Endnotes or footnotes can be inserted with word, How can it be done with
> Endnotes or footnotes can be inserted with word, How can it be done with
Manually, using superscripts, possibly extra text boxes, optionally the
line tool. Publisher does not have endnotes or footnotes built in.
Ed Bennett - MVP Microsoft Publisher
...confidentiality statement on all emails
How can I place a confidentiality statement on all emails
sent by the whole company. We are using Exchange 5.5.
Perhaps this KB can help:
"Joe" <firstname.lastname@example.org> skrev i en meddelelse
> How can I place a confidentiality statement on all emails
> sent by the whole company. We are using Exchange 5.5.
...HELP!!!Database tables list
Can someone explain me how i can obtain the list of tables contained in a mdb
files opening it at run-time by user, so that i can show the list in a list
in other words i need a VC++ app that let the user choose different mdb or
dsn and open them showing the contents in tables...but i must handle all the
process dinamically so i need open files or dsn then know the list o f tables
contained else how could i open them and show result?
take a look at the OLEDB interfaces. I know this exists, because several years ago we
considered using OLEDB and Access databases. For a variety...moving CRM databases
How can I relocate the CRM databases, on an existing
production CRM server, to a different partition on the
same server (i.e. from the D: drive to the F: drive) -
without re-installing CRM?
thx in advance,
Useing SQL Enterprise manager select database you want to move and then
chose option (after right click) detach database, fisicaly move database
files (*.mdf and *.ldf) and then attach database back to SQL Server.
"fgf" <email@example.com> wrote in message
> How can I relocate the CRM databases, on...External running of Access 2000 databases
Is there a way to make a mdb or mde viewable to someone that doesn't have
Access? I don't care how many conversions, if any, are nesseccary.
Look into purchasing Office 2000 Developer. It comes with a royalty-free
run-time version of Access that you can distribute with your application so
that people who don't have Access already installed can install the run-time
and use your application.
Unfortunately, Microsoft no longer sells previous versions of Access.
One possibility is to check out sites that specialize in old software
products, such as http://www.emsps.com/oldtools/ o...Grouping inserted pictues with Charts
Is there a way to group pictures and text boxes with a chart?
I was able to add textboxes and pictures and group them in the normal
way even if they where embedded within a chartobject.
Can you explain further what you are wanting to do?
> Is there a way to group pictures and text boxes with a chart?
Andy Pope, Microsoft MVP - Excel
I want to be able to put pictures, arrows, lines, text boxes, etc in a
chart so if I were to copy or move the chart, all of the things I put
in the chart will go with it....Excel Database
I need help with creating a name and address database
Use one header row.
One name per row.
Put each field into a different column.
different columns for
Honorific (mr., mrs. ms. the reverend, etc)
phone number (enter as numeric and format it as special|Phone)
And any other field you can think of should be a separate column. It's really
easy to combine two fields into one (=a1&" "&b1), but it's much more difficult
to separate them.
Different fields for each kid's...My "Compact & Repair Database" is missing !!
My "Compact & Repair Database" is missing. I cannot find it in TOOL-->
Just now, i tried to customize the location, so i dragged it to somewhere
else, now i cannot find it anymore !!
Pls help me to get it back !.
Thank you so much ^_^!
Allen Phailat Wongakanit
"ali" <firstname.lastname@example.org> wrote in message
> My "Compact & Repair Database" is missing. I cannot find it in TOOL-->
> Database Utilities.
> Just now, i tried to customize ...If Statements 12-03-09
trying to create an if statement, that if a certain cell is blank, it will
automatically pull from the next cell down, and so on. The only problem is
that I can't figure out, how to prevent it from pulling from the same cell
twice. Below is a sample of the formula I'm using.
...Insert copied row into a list
In Excel 2003, I can insert a row into a list by inserting a row into
the spreadsheet. That is, I can right-click along the row numbers
along the left, then insert a row.
However, if I try to insert a copied a spreadsheet row, I get the
message that I am trying to shift cells down within the list. That
is, I select a row by clicking the row number on the left, press ctrl-
C, then right-click another row on its row number at the left, and
choose insert copied row (or maybe insert pasted row -- I'm don't have
access to Excel at the moment to verify).
Inserting a copied/pasted row doe...Project Server databases move to network storage
Other than whatever a DBA normally does on the SQL Server 2005 side to
move databases to a different drive letter, are there any steps that
need to be taken on the application side to ensure things are in sync?
For those DBAs out there, is it simply about moving the data files
that the databases point to, or more than that?
Currently, our databases "live" on the C: drive of a dedicated
physical SQL Server 2005 box. Project Server is in a VMWare VM that
"lives" on another box. We wish to instigate a change where all the
data "lives" on another (SAN) ...Failing to Verify database in Crystal Reports
I'm trying to create custom reports based on custom fields that I have added
to CRM 1.2. I have read in this group that in order to see my custom fields
from Crystal I will have to first verify that database. But when I tried to
Verify my database I got this error:
failed to load database information.
Details: The database DLL 'crdb_mscrm.dll' could not be loaded.
What I've done is launch Crystal 9.2.2 Pro. and used the 'Enterprise' button
to find an exsisting CRM Crystal Report to modify. I then select a report,
click the 'database' pull down menu and s...Inserting an AutoDate Function
:confused: I want to format a cell to display the current date
(dd/mm/yy) upon opening the spreadsheet and automatically update the
same way Microsoft Word's AutoUpdate feature does. I have searched this
forum up and down and cannot find anything that tells me how to do this.
Some of the questions/answers here provide information on similar
topics, but I cannot find anything that simply tells me how to insert
an AutoDate in a cell. I can't possibly be the first person to have
asked this question. Can someone please help me?