Summary: hi i am trying to take the values from G17:J17 and write an if statement such as if G17:J17 is =8 then display in G19 "correct" if between 4 and 7 dis...
Summary: I need the following if statement in a word merge 'if statement' format. I really don't know how microsoft word structure their "If LOOPS" THIS is wha...
Summary: Hello!! i need some help in building a sql server select statement: i have a table with these columns and info: product_id | quantity -------------...
Summary: Both mdow and babaji have correct solutions (And Michael, except the join should be a left join as mdow suggested) , but mdow's will be much, much fas...
Summary: And what software are you using? Do you mean IF statement? Or IFF as in the subject or IIF as in your problem description? Life's more painless for ...
Summary: Hello all, My apologies if this has been answered previously, but I could not find anything specific enough to answer my question. I dare say it will ...
Summary: I'm creating an honor roll for my grades table. When I try to run an average on the output from this statement it gives me a data type mismatch. I'm...
Summary: I'm trying to create a db in office '07 for man hour accounting. Upon closing a job order I want to make sure that the Date Completed and Hours field...
Summary: If statements are IF something is Then do, this...Else...do something else. So, your If statement should read similar to (forgive the context, as I d...
Summary: MySQL supports IF statements in the form SELECT IF(t.title LIKE 'A %', Replace here, t.title) As Title FROM table t you can put IF statements within I...
Summary: Hi jhunt303, I quite sure I put the ODBC in system DSN already. One more thing is the data source name I use is same name with local PC name. When I t...
Summary: I was wondering where the best place to start learning a database language would be. I've been working with web development for some time now, (altho...
Summary: Hi I have been trying to merge multiple cells of date and time using A&" "&B but got strange result see below (38803 0.346643518518519) (27 March 2006...
Summary: Dear Friends, I am learning PL SQL for the first time. In one program I have given the dbms_output.put_line statement. While executing the program i...
Summary: May I ask if any sql statement to compare date with today and give the result on each record? e.g table Date Name 8/1/2008 Tom 27/12/2008 Ann 2...
Summary: I dont know if anyone can help me...but I got this error when trying to execute a function in a package: execute PKG_Q4.FN_Q4(ALT1); It is one of two ...
Summary: Im sad to say my father still uses nutshell database. Im trying to fix a stupid printing problem if anyone has the answer. when I print one of the fi...
Summary: When using SQL Server or MySQL, is there a way to create a statement to update/change a letter in a field. Specifically if I have a list in a specific...
Summary: This from the Help file in Act!: 1. If necessary, perform a lookup to find the contacts for whom you want to create mailing labels or envelopes. 2. Fr...
Summary: Hi, I need some help on Excel & Word documents, basically I need to create a macro so that when I run it it will send me to a Word document. So if I c...
Summary: Hello, I have been stuck on an SQL statement I have to write for class for extra credit. I have been trying to figure it out for literally hours. If...
Summary: I have two very different reports that I have to run to get all the info out of an inventory database. The first one extracts the current inventory, ...
Summary: I may not understand what you are attempting to do, but if I do, you do not need an IIF statement. You want to add criteria like this: ((DatePart("w...
Summary: I need help making tables with either mySQL or winSQL. Create the -Pilot- table with the following fields, PilotID (integer sequence) and Primary Key...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
