Easy query question for someone who knows Access

Need help, please.  I'm not a very experienced Access user so I am hoping this will be fairly easy for someone to answer.  I have a main table that has 5 diagnosis code fields as well as various other fields.  I want my query to bring back records of specific
diagnosis codes.  I have created a table of all the diagnosis codes that I want my main table to link to.
The matched code don't have to be in all 5 diagnosis code fields, just at least one of them.  One query I did kinda worked, but it only brought back records
where a matched diagnosis code was found in all 5 fields.  So needless to say it left out all the records where the diagnosis code matched in 4 or less fields.  Can someone please help?  Please, I’m desparate.

Keys to the Problem Easy query question for someone who knows Access

Download Error Fixer (Free)

Don't Download Malware

Where are you getting the download?

There are malicious people who download valid copies of a popular download, modify the file with malicious software, and then upload the file with the same name. Make sure you are downloading from the developer's web page or a reputable company.


Cancel or deny any automatic download

Some sites may automatically try start a download or give the appearance that something needs to be installed or updated before the site or video can be seen. Never accept or install anything from any site unless you know what is downloading.

Avoid advertisements on download pages

To help make money and pay for the bandwidth costs of supplying free the software, the final download page may have ads. Watch out for anything that looks like advertisements on the download page. Many advertisers try to trick viewers into clicking an ad with phrases like "Download Now", "Start Download", or "Continue" and that ad may open a separate download.

Another Safe way to Repair the Problem: Easy query question for someone who knows Access:

How to Fix Easy query question for someone who knows Access with SmartPCFixer?

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

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

3. When the Fixing part is finished, your computer has been speeded up and the errors have been removed


Related: Cant Download Or Open Programs..,Chm Compiles But Won't Run,Cd/dvd Driver Is Corrupt Or Missing-- Windows Cannot Load The Device Driver For This Hardware. The Driver May Be Corrupted Or Missing. (Code 39),Cant Get Messanger To Boot Up,Change The Letters Into Asterisk While Typing In The Cell!!,Computer Does Not Shut Down Instead It Restarts...,Conditional Formatting - Highlight Several Sets Of Duplicates,Computer Freezing After Updates,Conditional Format Search Part Of Text,Computer Repeated Freeze Requiring Hard Reset, And Many Other Queries,Deleting Messages From Deleted Items Folder,Delay Before Next File Starts After A File Has Finished Copying To Or From USB.,Default Search Provider Error,Dell Running Windows 7 Is Running Very Slowly,Dell Inspiron 1525 Webcam Issue.,How To Use Digital Signage To Reach College Students,One Simple Strategy To Organize Your Online Business,The Next Generation: Xbox 360,Best Home Storage Organization Tips,Learn To Sing Fast
Read More: How to Fix Error - Does Combat Flight simulator work on Windows 7 Home Premium??,Troubleshooting:DOS command that lists all software programs and versions Error,How to Fix Error - Does the Foxpro OLE driver listed below work with Windows 7??,Double Search windows when starting internet explorer,Troubleshoot:Edit Links: the Source is this workbook edited on my home computer - Change source is grayed out,Dell XPS laptop running Windows 7, monitor switches off after 2 mins idle time, but should be set to 15 minutes,deleted emails from windows live eamil account can i get those back deleted on Oct. 24 2009,Do anyone know about the EULA for AutoRoute 2007?,Driver does not read video dvd,Display bug in Excel 2007 and 2010. What to do?
[PR]
by rpcserver | 2016-09-30 10:19

Driver Power State Failure BSOD

Hi All.
 
Have seen previous threads regarding this issue but they appear to be closed off to new replies.
 
I need some help examining the following Minidump files to work out what driver, dll etc is the cause of my Blue screen issue.
Seems to happen whenever the power management kicks in to put the laptop to sleep.
 
https://dl.dropbox.com/u/31303664/Minidump.zip
 
Any help would be appreciated.
 
O/S is Windows 7 Ultimate x64 with SP1.
 
Thanks.
 
Rob.

Anwsers to the Problem Driver Power State Failure BSOD

Download Error Fixer for Free Now

If you failed to fix it, another option is to call Microsoft and walk through the process with a technician. To do this, dial "1-800-936-5700". Explain the error that you received and the steps in the update process during which it was displayed. The technician will be able to walk through the steps from getting a new product key to finishing the installation.

Recommended Method to Repair the Problem: Driver Power State Failure BSOD:

How to Fix Driver Power State Failure BSOD with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your system.  Open it, and it will scan your computer. The junk files 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. When the Fixing part is done, your computer has been speeded up and the errors have been removed


Related: Cant Download From Internet,Changing The Date/time Format In A Code,Cant Activate Autodesk CAD - Javascript Impaired Or Disabled Under Local Security Settings.,Changing Serial Port Numbers,Check Duplicates With Function,Computer Stopped Connecting To My Wireless Router.,Computer Locks Up A Few Minutes After Logon,Computer Suddenly Shuts Down With Minidump,Computer Mystically Reset To Factory Also,Connecting To My Wireless Router, It Assigns Itself As A "unidentified Network" And States "no Internet Access",,Data Execution Prevention In Vista,Cut Scenes With Movie Maker I Do Not Want,Defrag Report States System Volume Infomration File Cannot Be Defragged. How Can I Correct This?,Date Comparison Formula,Customizer 10000 Plus Unable To Load,The Benefits Of Cadio Training,What Is A Frequency Generator?,Mock-Wrap Scrub Tops Your All Time Favorite,What Is The Most Effective Method To Quit Smoking? Hands Down Hypnosis.,Promotional Pharmaceutical Items Keep Your Company Healthy
Read More: Troubleshooting:Does anyone know how to reset the page size after making an envelope in Word?,Distinct sounds which comes from the computer; distinguishably from the speakers and an audio problem!,How to Resolve - Disk Defragmenter shows \"System\" Icon but cannot be defragmented??,Fast Solution to Problem: Do I have a keyboard problem?,Troubleshoot:Display of web pages too dark,Deleted Link to Favorites,Download Activex on Vista : (Error: Faulting application IEXPLORE.EXE, version 8.0.6001.18865...),Does a modem restrict the number of internet users?,does windows rt support opera or firefox,Downloaded files are not saved
[PR]
by rpcserver | 2016-09-30 09:51

Combine 2 formulas in same cell...

I need help combining the following 2 formulas;  =IF(L6>40,40) and =IF(L6<40,E7+F7+G7+H7+I7).
 Thanks.

Solutions to the Problem Combine 2 formulas in same cell...

Download SmartPCFixer to Fix It (Free)

=IF(L6>40,40,E7+F7+G7+H7+I7)
 
and if L6 = 40, treated like <

To install drivers and other optional updates

  1. To install optional updates, you need to review and then select them from the list of updates that Windows finds for your computer. Optional updates are not installed automatically.
  2. Open Windows Update by clicking the Start button Picture of the Start button, clicking All Programs, and then clicking Windows Update.
  3. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer.
  4. If any updates are found, click View available updates.
  5. Select the optional updates that you want, and then click Install. Administrator permission required If you are prompted for an administrator password or confirmation, type the password or provide confirmation.

Recommended Method to Fix the Problem: Combine 2 formulas in same cell...:

How to Fix Combine 2 formulas in same cell... with SmartPCFixer?

1. Click the button to download SmartPCFixer . Install it on your computer.  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 done, you can see the errors and problems which need to be repaired.

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 SmartPCFixer. Like dll downloading, junk file cleaning and print spooler error repair.


Related: Cannot Access Favorites,Cannot Install I Tunes Or Quick Time Player,Cannot Disable Local Area Network,Cannot Find My Internet Explorer 8 Tool Bar,Can't Update/download And Problems With Antivirus Software.,Cannot Run A Server Based Program On Windows 7 Machine,Cannot: Access Internet Options; Download Files; Allow 'Temporary Pop-Ups; And I've Lost The Favourites Toolbar!,Cannot Save Or Save As A Document That We've Worked On Before,Cannot Start Up In Safe Mode,Cannot Unpin Uninstalled Program From Taskbar,Cant Install Any New Programs...Help!!,Capturing Running Processes On Windows OS.,Change Chart With Secondary Axis From Stacked To Cluster,Click-To-Run Application Manager (x) Microsoft Word Starter 2010 Cannot Be Opened. Try Again Or Repair The Product In The Control Panel,Can´t Install Programs - Either No Access To Temp Folder Or Windows Installer Denies Service Depends On Program To Install
Read More: change the decimal point to a comma,CD/DVD Burning Always Fails Tech Support,How to Fix Error - Change type of Avery label a document has been formated to.?,Fast Solution to Problem: clear disk space for download,How Can You Fix - Change Default Carriage Return Font and Point?,Can send email but cannot reply or forward emails,Cannot establish an account with Winqual as the site does not have this link,Cannot access any programs and icons changed to e(explorer),Cannot connect to Router via wireless or Ethernet cable unless router is unplugged and replugged.,CD formatted in CDFS won't open> says no program asssoicated
[PR]
by rpcserver | 2016-09-19 17:25

Cannot share printer between Win 7 64 and XP 32

When I try to connect a shared printer on new Win 7 64 bit computer from XP 32 bit machine, I get a message saying printer will install a driver on XP.
Every attempt fail becase of "incorrect" drivers.
I presume the 64 bit driver on W7 does not have a
32 bit version to install on XP.

I want to share a printer connected to a W7 64 computer from a 32 bit XP machine.
How can I do this?

Everything worked well when I was running XP to XP before upgrade to new W7 computer

Solutions to the Problem Cannot share printer between Win 7 64 and XP 32

Download SmartPCFixer to Fix It (Free)

Try adding the printer as a "local printer" in XP:
Start > Control Panel > Classic View > Printer and Faxes > Add a printer > Next >  then select "Local printer attached to this computer and un-check "Automatically detect and install my plug and play printer" > Next > then select "Create a new port" and
in the drop-down box  make sure "Local Port" is selected for "Type of Port" > Next >  then under "Enter a port name" enter the path to the networked printer - \\computer name\printer name > OK
At this point you may be asked for the "drivers" for the printer however I would suggest to install, in Windows XP, the correct 32-bit XP drivers  for the printer beforehand.

  • 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.

Recommended Method to Fix the Problem: Cannot share printer between Win 7 64 and XP 32:

How to Fix Cannot share printer between Win 7 64 and XP 32 with SmartPCFixer?

1. Click the button to download Error Fixer . Install it on your computer.  Open it, and it will scan your computer. The errors 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 Fixing part is finished, the speed of your computer will be much higher than before and the errors have been removed.


Related: Base Filtering Engine Service Is Not Running On The Computer​.,Battery Notification Not Showing,Bex Error- How Can I Fix This,Black Screen On Startup And When Trying To Switch Users?,BCCode:9f Every Time When Windows 7 Comes Back From Suspend Mode,BSOD Windows 7 Profesional 64bit (Wdf01000.sys),Bug In MS Word 2010 Regarding Folder Naming And "Save As" Command,Break A Table Into Two Tables In Excel 2007,Calculating Min, Max And Average Over Multiple Columns Within A Pivot Table.,Calculating A Start Date In Excel.,Can You Insert Image Into A Comment In Excel,Can't Access Windows Live Family Safety From IE8 Or IE9 - Continuous Loading,Can't Drag & Drop On Programs Win7 X64,Can't Connect To Internet Keeps Telling Me To Check Internet Connection Then Starts To Run A Diagnostic,Can I Use My Acer Laptop To Extract Wireless Modem Information Via U.S.B. To Connect A Desk Top,Can't Install ITunes On 64-bit Computer,Can't Open Yahoo Mail In Windows 7,Can't Install Windows Update Error Code 0xc8000247,Can't Install Net Framework 4 Client,Can't Open Downloaded Documents In Word And Excel
Read More: Cannot uninstall PaperPort 8 [Anwsered],[Solved] Cannot see mouse cursor when remoting into Windows 7 machine.,Solution Cannot sign in on my Windows Live ID to acces Hotmail as it says Java Script required how can I resolve this problem,Troubleshooter of Error Cannot view Computer properties Windows Update Action Center,cannot uninstall Juno internet software from Windows 7 Enterprise 32 Tech Support,Can't connect to a Home network on homegroup,Can IE's orange RSS link be changed to open the Google Reader?,Can I send a JPEG file in a PDF form ?,cannot delete older version of quicktime,CANNOT connect Windows Mobile device to Windows Mobile Device center in Win 7
[PR]
by rpcserver | 2016-09-14 11:42

Can't install older programs in Windows 7 laptop

Hi ..i have art explosion T-shirt factory ...  which i am trying to put on to my new laptop .windows 7  i have used this program for years without any problems installing it ..but  this just will not download on to windows 7 ..i have been through all options
i can see on the internet ..but NO IT JUST WONT GO ON ......  soo  help there must be someone out there that can help ......
 
Original Title: Help ..anyone in the know .....
windows 7 is a nightmare to install programs __

Keys to the Problem Can't install older programs in Windows 7 laptop

Download SmartPCFixer for Free Now

Hello lyndi 246,
These are the options you have to make older programs compatible with Windows 7.
Some may be repeated from posts above.
If the program is not compatible, then you may try to install and run the program in compatibility mode.
Use the following steps:
1)      Right click on the Program
2)      Click on Properties
3)      Click on Compatibility tab
4)      Select Run this program in compatibility mode and select Windows Vista, Windows XP or whatever operating system the program was running successfully.
 
 
Refer to the link here: Make older programs run in this version of Windows
http://windows.microsoft.com/en-us/windows7/Make-older-programs-run-in-this-version-of-Windows
 
If you run Windows 7 Professional or Ultimate version, install Windows Virtual PC and Windows XP mode (http://www.microsoft.com/windows/virtual-pc/default.aspx)
and execute your software in Windows XP.
 
If you run Windows 7 Home Premium, try VirtualBox (www.virtualbox.org) or VMware Player (www.vmware.com) or any
other 3rd party virtualization software and install a separate copy of Windows XP (either Home Edition or Professional) for that purpose.You can find virtualization software free of charge that will run on Windows 7 Home Premium.
  
If the compatibility is not successful, then try and runthe Program Compatibility troubleshooter:
 
1.    Open the Program Compatibility troubleshooter by clicking theStart button.
Then clickControl Panel.
In the search box, typetroubleshooter, and then clickTroubleshooting.
Under
Programs, clickRun programs made for previous versions of Windows.
2.    Follow the instructions in the troubleshooter.
If you cannot install a program, insert the installation disc for the program and, using the troubleshooter, browse to the program's setup file, usually called Setup.exe, Install.exe, or something similar.
The troubleshooter is not designed to work
on programs that have an .msi file name extension.
Hope this helps.
 
Sincerely,

Marilyn
Microsoft Answers Support Engineer
Visit our
Microsoft Answers Feedback Forum and let us know what you think

If you failed to fix it, another option is to call Microsoft and walk through the process with a technician. To do this, dial "1-800-936-5700". Explain the error that you received and the steps in the update process during which it was displayed. The technician will be able to walk through the steps from getting a new product key to finishing the installation.

Recommended Method to Fix the Problem: Can't install older programs in Windows 7 laptop:

How to Fix Can't install older programs in Windows 7 laptop with SmartPCFixer?

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

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

3. The Repair part is done, 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: Belkin USB Wireless Adapter Not Working With Windows 8.1,BeGraphic Add-In For Excel - UI Error,Bad Pool Header BSOD,Battery Or Adapter Problems Or Is It Just Dell Products Are Awful!,BCCode: 10000009f - Random Blue Screens At Startup And Shutdown,Can't Boot Windows 8 - Black Screen, Blinking Underscore,Can't Change Chart Bar Colors,Can Not View Streaming Live Webcams,Can IE9 Be Set To Warn When Closing Multiple Tabls Which Is Not The Last IE9 Window?,Can You Give Someone Programs From Your Computer On A Disk On A Limited Account
Read More: How Can I Fix - Can't find HP 990c driver for HP 6122 install on Windows 7 64 bit system?,How to Fix Error - Can you explain this code to me??,How to Fix - Can not install update KB2509553 on OS Win XP.....many times attempted?,Can't access files after system recovery,Can't install SP1 - ERROR_SXS_ASSEMBLY_MISSING(0x80073701) [Solved],Can anyone tell me what Error code 39 is? My drivers for my camera and mic say error code 39.,Can not upgrade to Windows 7 Service Pack 1,can i uninstall java TM se runtime environment 6,Can I stop a reset?,can't download skype on my new computer
[PR]
by rpcserver | 2016-09-08 12:48