•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS Access and FileMaker Pro section within the Web Development category of DaniWeb, a massive community of 423,580 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,386 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS Access and FileMaker Pro advertiser: Programming Forums
Views: 637 | Replies: 2
 |
•
•
Join Date: Mar 2008
Posts: 2
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hi guys,
I'm fairly new to MS Access and I am running Ver.2003.
I have a problem with comparing a Excel speadsheet with an Access DB.
The result I require is as follows....
If field 'Last' and ID Num in Excel speadsheet matches 'Last' and EmpID in Access DB then place 'Y' in MBR field ( 1st field) in Excel speadsheet else 'N'
The 'Y' and 'N' can be a numeric if this is easier and I could then change the numeric to a alpha 'Y' or 'N' later.
If anyone can help me I would be extremely grateful.
Thanks
Ashley
I'm fairly new to MS Access and I am running Ver.2003.
I have a problem with comparing a Excel speadsheet with an Access DB.
The result I require is as follows....
If field 'Last' and ID Num in Excel speadsheet matches 'Last' and EmpID in Access DB then place 'Y' in MBR field ( 1st field) in Excel speadsheet else 'N'
The 'Y' and 'N' can be a numeric if this is easier and I could then change the numeric to a alpha 'Y' or 'N' later.
If anyone can help me I would be extremely grateful.
Thanks
Ashley
•
•
Join Date: Jan 2007
Posts: 2,556
Reputation:
Rep Power: 7
Solved Threads: 114
This might work better if you export the Access table as an Excel spreadsheet, then add it to your existing Excel spreadsheet as another sheet tab.
You can use quoted strings in both the condition and the results in if functions in Excel. Examples:
You can use quoted strings in both the condition and the results in if functions in Excel. Examples:
=IF(C5="Y",=C6*$A$4,0) =IF(F7=Access_Sheet!F7,"Y","N")
Last edited by MidiMagic : Mar 8th, 2008 at 11:18 pm.
Daylight-saving time uses more gasoline
|
•
•
•
•
•
•
•
•
DaniWeb MS Access and FileMaker Pro Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Questions about building a system (was: newbie) (Troubleshooting Dead Machines)
- As a newbie, where i should start from in linux? (Getting Started and Choosing a Distro)
- Best free C/C++ compiler for a newbie? (C++)
- help newbie alert needs help with login page (ASP.NET)
- newbie needs help, basic mfc stuff (C++)
- Hello, newbie here... (Geeks' Lounge)
- Book For Newbie (C++)
- Newbie - how do I start C++ programming? (C++)
- PHP newbie, project feasibility (PHP)
- How to network two Win98 machines (Networking Hardware Configuration)
Other Threads in the MS Access and FileMaker Pro Forum
- Previous Thread: ms access and sybase connecting
- Next Thread: Migrating from access to Filemaker/Copy Paste Help
