Complex if statement in MSQuery (Excel)

I have the following query in Excel (MSQuery) and it works just fine:
SELECT HistoryHeader.CustomerCode, CustomerMaster.CustomerDesc, HistoryHeader.SalesmanCode AS 'RepCode', SalesmanMaster.Description AS 'Rep', HistoryHeader.DocumentDate, year(HistoryHeader.DocumentDate) AS 'DocYear', month(HistoryHeader.DocumentDate) AS
'DocMonth', if(month(HistoryHeader.DocumentDate)<=6,'S1','S2') AS 'Semester', HistoryHeader.Total-HistoryHeader.TotalTax AS 'DocTotal'
FROM CustomerMaster CustomerMaster, HistoryHeader HistoryHeader, SalesmanMaster SalesmanMaster
WHERE CustomerMaster.CustomerCode = HistoryHeader.CustomerCode AND HistoryHeader.SalesmanCode = SalesmanMaster.Code
However, when i try to add a Quarter as if(month(DocumentDate)<=3,'Q1') as 'Quarter' it falls over...
i have tried numerous times with varied syntax but it just won't work.
can anyone perhaps assist as i'm rather frustrated with this at the moment.
Thank you in advance.

Solutions to the Problem Complex if statement in MSQuery (Excel)

Download SmartPCFixer to Fix It (Free)

Since you’re using Microsoft Query, you may post your query in the Excel IT Pro forum link, for better suggestions on the issue.
http://social.technet.microsoft.com/Forums/en/excel/threads

Run CHKDSK
  • Go to the Start button.
  • In the Search box, type "cmd" (without quotes) and press Enter.
  • At the command prompt, type "chkdsk /r /f" (without quotes) and press Enter.
  • Restart your computer.

Another Safe way to Fix the Problem: Complex if statement in MSQuery (Excel):

How to Fix Complex if statement in MSQuery (Excel) with SmartPCFixer?

1. Download SmartPCFixer. Install it on your computer.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been removed. You can also use other functions in SmartPCFixer. Like dll downloading, junk file cleaning and print spooler error repair.


Related: Can't Sign Out Of Windows Live Hotmail,Cannot Find Outlook Mail After Upgrading To Windows 7! Have Installed Windows Live Mail!,Cannot Do Anything That Requires Admin Privileges With Windows 8.,Cannot Get Driver For Creative Zen Micro For WMP Windows 7,Cannot Download Adobe Acrobat 9,Cannot Send Or Receive E-mails, Error Number: 0x800CCC0E,Cannot Open Or Print Multiple Documents In Word,Cannot Rename Hard Drive In Windows Explorer On Windows 7,Cannot Use MS Office Program Edit Online Office File By WebDav At Win7,Cannot Send Documents As An Attachment,CF Problem,Cant Send Photos To Www.nlop Players.com Or Http://www.mixed Venue Poker.com/index.php Please Fix,Cell Fill Colors Disappear - High Contrast Option Is Off,ChkDsk Locks Up In Windows 7,Charting Not Applicable Data
Read More: Change Default Language for new Email in outlook [Solved],[Solution] Change default Picture Viewer,How to Fix - combine several different worksheets onto a master sheet??,Troubleshooting:Compatibility problems Error,How to Fix - Combined date & text for date/time value?,can't find product or version info,Cannot connect ipad to VAIO via bluetooth,cannot locate file to install silverlight, windows 7 64 bit, c:\6f4c8317905ddd8e80bc5f1b238f5ea2\,change sheet name,Cant' make a Restore point, no System Restore
[PR]
# by installerror1601 | 2016-09-19 17:28

Cannot receive friends email.

Cannot receive friends email.

My friend and I are both on Outlook 2010.
Recently I have unable to receive messages from him although he can receive mine.
And it’s not going into Junk mail.
He cannot even receive his own emails.
Do you have any suggestions?

Anwsers to the Problem Cannot receive friends email.

Download Error Fixer for Free Now

Does he get any bounce messages?
Is he able to successfully send to ANYONE?
What kind of account is this?  POP3? IMAP? Hotmail? Exchange? Something else?

Make Sure that your Computer Meets the System Requirements

This error can be due to some configuration requirements for you system. If your PC hardware is not up to par, then make sure you upgrade where necessary before continuing:

Microsoft Windows Requirements :

  • 1 gigahertz (GHz) or faster 32-bit (x86) or 64-bit (x64) processor
  • 1 gigabyte (GB) RAM (32-bit) or 2 GB RAM (64-bit)
  • 16 GB available hard disk space (32-bit) or 20 GB (64-bit)

If your computer meets the minimum requirements above, then continue on…

Recommended Method to Repair the Problem: Cannot receive friends email.:

How to Fix Cannot receive friends email. with SmartPCFixer?

1. You can Download Error Fixer here. Install it on your system. When you open SmartPCFixer, it will perform a scan.

2. After the scan is done, you can see the errors and problems which need to be repaired.

3. The Repair part is done, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in SmartPCFixer. Like dll downloading, windows updating and print spooler error repair.


Related: Battery Life Monitor Seems To Vary Quite A Bit,BIOS Defaults Changing,Basic Question How Do I Imput A Formula To Calculate 5 Or 6 Columns?,Before Installing Windows 7 I Backed Up All My Files. I Was Running Vista. My Problem Is How Do I Restore My Files From Backup?,Bibliography And Citation Issues,Burning Problem Error Code 0x80004005,BSOD - Kernel Data Inpage Error, Then System Thread Exception Not Handled And Lastly Dpc Watchdog Violation,Bluetooth Peripherals No Longer Waking Computer From Sleep After Windows 8.1 Upgrade,C:\windows\system32\MFC42u.dll Is Either Not Designed To Run On Windows Or It Contains An Error, Opening MSCONFIG, MMC Or Paint,Borders Print Onto Labels From Merge,Can't Download Windows Updates,Can You Restore Individual Files From A Full Image Backup,Can MS Reporting Services Be Installed To An Alternate Location Like E:\Program Files?,Can't Download Itunes,Can't Access Google But All Other Websites Work? PLEASE HELP!!!,Can't Send Emails Via Windows Mail,Can't Get To Microsoft Websites,Can't See The Content In My W7 Recycle Bin,Can't Reinstall Quicktime And Itunes.,Can't Open PDF's I Receive In Emails
Read More: cannot sign into widows messenger__,How to Fix - cannot read chinese characters in windows 7 ultimate?,Tech Support: Cannot Use My Computer After I Reseted to Factory Settings.,Solution Cannot sign in on my Windows Live ID to acces Hotmail as it says Java Script required how can I resolve this problem,Anwsered Cannot read mails using Windows Live Mail,Can't click some control panel links,Can one use Microsoft Outlook 2007 on a PC that has Windows 7 64-bit format?,Cannot connect to any ftp sites IE8/Win7(X64),Cannot open a URL link from Outlook 2010 email message unless IE 9 is already open.,Cannot Move Word Documents
[PR]
# by installerror1601 | 2016-09-14 11:42

Can't open Excel 2003 file in Excel 2010 on windows7

I am running Windows 7 64-bit OS and have Excel 2010 installed at home.
I can't open any Excel 2003 (.xls) files.
The error message is: "The document is corrupt and cannot be opened.
To try and repair it, use the Open adn Repair command in the Open dialog
box and select Extract Data when prompted."
 
I have no problem to open the excel file on XP at work so I emailed the file to myself.
I saved the file to my desktop and open the file again at home.
Now I am getting another error message: "Excel found unreadable content in 'file name.xls'.
Do you want
to recoever the contents of this workbooks? If you trust the source of this workbook, click Yes." When I click Yes, nothing happens.
 
Can someone please help?

Anwsers to the Problem Can't open Excel 2003 file in Excel 2010 on windows7

Download SmartPCFixer for Free Now

There is no easy fix to the problem but see if the workaround suggested in these help you.  It may have something to do with increased security in Windows 7 that is not seen in XP or Vista?
 
Excel found unreadable content in 'xxx.xls' (Windows 7 only)
http://social.msdn.microsoft.com/Forums/en-US/exceldev/thread/69434b37-a3ed-4970-a929-89e03ee01aaf/

Corrupt Excel files in Windows 7
http://www.google.com/support/forum/p/affiliatenetwork/thread?tid=2b5983fcbe55ea27&hl=en

  • Download the Microsoft Windows ISO (installation device) from the following website:
  • http://www.microsoft.com/en-us/software-download/windows10
  • Users must select the appropriate ISO, either 32 bit or 64 bit, depending upon their individual computer.
  • Extract the ISO file to a separate USB device or burn the program to a compact disc.
  • Run the Microsoft Windows 10 upgrade directly from the software that you have thus created.

Another Safe way to Fix the Problem: Can't open Excel 2003 file in Excel 2010 on windows7:

How to Fix Can't open Excel 2003 file in Excel 2010 on windows7 with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system.  Open it, and it will perform a scan for your system. The errors will be shown in the scan result.

2. After the scan is finished, you can see the errors and problems which need to be repaired.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been fixed.


Related: Belking External Cooling Fan,Baixar Mfc.100dll,Base Score Improvement,Battery Loves To Slip On A Dell Latitude E6400, Windows 7 32 Bit.,Bad Problem: Computer Jump/Glitch At Regular Intervals,Can Only Start In Safe Mode,Can't Add Gmail IMAP Account To Windows Mail On Other Vista Computers,Can Not Down Load Itunes On My Pc Can Any Body Tell Me Why,Can't Figure Out How To Get My Code To Run The Right Way,Can't Download Itunes 9 Will Not Let Me Change Drive Letters
Read More: Can not add to favorites and my list of favorites are no longer appearing. [Solved],Can't change background in Windows Starter Tech Support,Solution to Problem: can not send mail on ipad2 iphone4 and normal pc,Troubleshoot:Can Not Access One Computer On a Home Network (But It can access the others),[Solution] Can we get IIS feature in Windows7 home basic,Can I use my Virgin Broadband cable for both internet and fax?,Can't access certain programs when looged in under different user accounts,Can Streets & Trips's maps be uploaded to FORD's SYNC using the SD Flash card?,Can no longer receive bellsouth mail in yahoo plus but I can send. Works fine in Firefox,Can I use Sony digital Voice Recorder with windows vista Speech Recognition?
[PR]
# by installerror1601 | 2016-09-08 12:50

Calculating number of years + given date

I made a Formula in (Cell B1) to calculate the period between a given date (Cell A1), and Today ().
This is the Formula in (Cell B1);
=DATEDIF(A1,TODAY(),"y")&" Y- "&DATEDIF(A1,TODAY(),"ym")&" M - "&DATEDIF(A1,TODAY(),"md")&" D"
 
Now I have to add a Column (Column C), this column contains number of years.
 


01/01/12

0 Y- 3 M - 22 D

3


Column (A)

Column (B)

Column (C)


 
 
Now the Formula in Cell (B1) has to be change, I need a Formula to reflect the number of years + the result in Cell (B1).
 
The result will be 3 Y – 3 M – 22 D.
 
Could you please help me in this.

Solutions to the Problem Calculating number of years + given date

Download SmartPCFixer to Fix It (Free)

...
Now I have to add a Column (Column C), this column contains number of years ...

You can adjust TODAY() by constructing an offset date value using either DATE() or EDATE() like this,
DATE(YEAR(TODAY())+C2,MONTH(TODAY()),DAY(TODAY()))
...
or,
EDATE(TODAY(),C2*12)
...
then use that value in your previous formula.

            

The formula in D2 is,
=DATEDIF(A2,DATE(YEAR(TODAY())+C2,MONTH(TODAY()),DAY(TODAY())),"y")&" Y- "&DATEDIF(A2,TODAY(),"ym")&" M - "&DATEDIF(A2,TODAY(),"md")&" D"
...
and the alternate formula in E2 is,
=DATEDIF(A2,EDATE(TODAY(),C2*12),"y")&" Y- "&DATEDIF(A2,TODAY(),"ym")&" M - "&DATEDIF(A2,TODAY(),"md")&" D"

I don't think you will find it necessary to adjust all three of the TODAY() values since you are only adjusting by an integer worth of years but some testing may be worthwhile around Feb 29 of a leap year.


DATE function

EDATE function

YEAR function

MONTH function

DAY function

TODAY function

Using Windows troubleshooter:

  • Click on Search on Charm bar and type Troubleshooting. Click on the very first option.
  • A new window will open. Click View all from the left pane.
  • Scroll down to the bottom and click on Windows update.
  • Troubleshooter window for Windows update will pop up. Click on NEXT. It may ask you for administrative permission.
  • The troubleshooter will automatically detect problems and fix it.
  • Now, close this window and try download/install the app which was previously showing error.

Recommended Method to Fix the Problem: Calculating number of years + given date:

How to Fix Calculating number of years + given date with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your system.  Run it, and it will scan your computer. The junk files will be shown in the list.

2. After the scan is finished, you can see the errors and problems which need to be repaired.

3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been removed.


Related: How to Update ASUS Xonar D2X driver for Windows XP 32/64-bit,Update ATI VGA Driver version 6.13.10.5779,How to Download Chicony Camera Driver version 61.005.029.1900,Download OKI C9800(PCL),How to Update TI Card Reader Driver version 2.0.0.10,Method to Download Toshiba Portege R835-P83 eco Utility v.1.3.21.0 driver,Method to Download Toshiba Satellite A660-BT2N23 Face Recognition v.3.1.3 driver,Download Toshiba Satellite L355-S7907 Face Recognition v.2.0.17.32 driver,[Solved] Download Toshiba Satellite L740-BT4N11 PC Health Monitor Utility v.1.7.9.64 driver,How to Download Toshiba Satellite P305D-S8828 WPS Library v.1.0.0.7 driver,Best Way to Download NVidia GeForce 6100 VGA Driver v.304.51 Certified,How Can You Update & Download NVidia GeForce 9300/nForce 730i VGA Driver v.310.19 Certified,Method to Download NVidia GeForce GT 330M Driver v.340.65,How Can I Update & Download NVidia GeForce GTX 590 Driver v.280.26 WHQL,Method to Download NVidia Tesla C2050 Driver v.319.17
Read More: How to Fix - can i reinstall a corrupted Windows 7 system reserved partition??,Fast Solution to Error: Can formulas take into account the color of the cell on the spreadsheet?,Can I install a XP printer driver in XP Mode? If so, can I use it from Win 7? Tech Support,Troubleshooter of Error: Can I change English language on Windows 8 to Polish?,Tech Support: Can I get a replacement disk if my PC fails,BSOD after upgraded to Windows 8.1 (memory problem?),Blurry programs on Windows 8.1,C:\Window|Microsoft.Net\Framework\v4.0.30319\mscoreei.dll could not be loaded,Browsing history is no longer visible,Bulk deleting from email deleted items folder
[PR]
# by installerror1601 | 2016-08-26 15:19

bluetooth driver, windows 7, x64, mini usb bluetooth dongle

I bought a bluetooth dongle from ebay (those really cheap ones).
It doesn't come with software/drivers.
I plugged it in my windows vista laptop and it worked smoothly.
When I plug it in my windows 7 x64 laptop, it says "Unknown device," "USB device
not recognized."  Where can I find the right drivers for this bluetooth dongle?

Few screenshots are as follows:
http://img12.imageshack.us/i/bluetoothnotworking.jpg/
http://img410.imageshack.us/i/csrdevicenotfound.jpg/
http://www.getdirect.com.au/images/Mini%20Square%20Dongle%20main.jpg

Keys to the Problem bluetooth driver, windows 7, x64, mini usb bluetooth dongle

Download Error Fixer (Free)

Hi,
Go to www.bluesoleil.com and download their proggie:
http://www.bluesoleil.com/download/Detail.aspx?TID=26
It is a fully functional demo.
See if it works for you (it did for me).
If it does, then you'll have to shell out (like me) 20 euros.
It works with most of the "abandoned", "old" bluetooth USB devices.
Best of luck.
Carlos

Use the System File Checker tool to repair corrupted or missing system files:

  1. Click Start.
  2. Type cmd, and then press CTRL+SHIFT+ENTER to open the elevated command prompt (I.e. Command prompt with administrative rights).
  3. The User Account Control window should appear, be sure that the action it exhibits is correct, and then press the Continue button.
  4. Type or copy paste the below command line into it without quotes:
  5. "Sfc /scannow"

Another Safe way to Repair the Problem: bluetooth driver, windows 7, x64, mini usb bluetooth dongle:

How to Fix bluetooth driver, windows 7, x64, mini usb bluetooth dongle with SmartPCFixer?

1. Download SmartPCFixer . Install it on your computer.  Click Scan, and it will perform a scan for your computer. The junk files will be shown in the scan result.

2. After the scan is done, you can see the errors and problems which need to be fixed.

3. The Repair part is finished, the speed of your computer will be much higher than before and the errors have been fixed. You can also use other functions in this software. Like dll downloading, junk file cleaning and print spooler error repair.


Related: Belkin USB Wireless Adapter Not Working With Windows 8.1,Best Way To Create/update Dynamic Range In Excel 2007,Belkin Hispeed Usb Firewire,Bing Cashback Program Troubles,Best Way To Enter Time In A Cell
Read More: Troubleshoot:Battery Notification icon disappeared and Im unable to turn it on (on option is greyed out),[Solved] Black screen on wake-up, but mouse moves cursor arrow,Tech Support: Belkin F5U237v1 7-Port USB Hub,Backup Windows 7 and Restore without removing other partitions Tech Support,Troubleshoot:beta dashboard status code 831188FB,Bing Toolbar has stopped working,bios application not found,bad results when using "find" box on WLM2011, filtered by dates,Black screen on Admin account, but not on standard user account,battery light inconsistent blinking orange and green
[PR]
# by installerror1601 | 2016-08-10 17:32