Making database report with three databases. I have done this before but it was in 2005.
Ok, I have 3 databases.
Db2: (Labor):Activity(text), Description(text), Begin Date(date), end date(date), Pay Period(text), boat category(text), Boat Name(text), Pay_table1(text), Pay_table_2(text), Employee Name(text), regular Hours(text), actual costs(currency), overtime costs(currency),
Db3 Travel: Activity Name(lookup table), Last_name(text), First Name(text), boat_name, Boat Category(text), begin date(date), end date(date), estimated costs(currency), Actual costs(currency), travel order number(text), Trip purpose(Memo), destination(text),
Project charged(text), date issued(date.
what I am looking to do is combine on a report the data as such:
Employee Name, begin date, end date, travel order number, and all other pertinent data. Do I do a report based on a query and then link parent/child fields. Please help.
Anwsers to the Problem Making database report with three databases. I have done this before but it was in 2005.
I haven't found a primary key that does not have duplicates. What do I do in this situation?
Then what you do is use a surrogate key.
In fact this is what I recommend in almost every situation.
A surrogate key is an arbitrary unique number that is generated by the system to be used as a primary key.
Access has a datatype called Autonumber which is
designed specifically to use as a PK. Add autonumber PKs and then ____ the corresponding values as FKs.
Hope this helps, Scott<> P.S.
Please post a response to let us know whether our answer helped or not.
Microsoft Access MVP 2010 Blog: http://scottgem.wordpress.com Author: Microsoft Office Access 2007 VBA Technical Editor for: Special Edition Using Microsoft
Access 2007 and Access 2007 Forms, Reports and Queries
- Go to the Start button.
- In the Search box, type "regedit" (without quotes) and press Enter.
- Look for the following registry key: "HKEY_LOCAL_MACHINE\SOFTWARE\ Microsoft\ SQMClient\Windows\DisabledSessions".
- On the right window pane, delete the subkey: "Machine Throttling".
- Restart your computer.
Another Safe way to Fix the Problem: Making database report with three databases. I have done this before but it was in 2005.:
How to Fix Making database report with three databases. I have done this before but it was in 2005. with SmartPCFixer?
1. Download SmartPCFixer . Install it on your system. Click Scan, and it will perform a scan for your computer. The junk files will be shown in the list.
2. After the scan is done, 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: Sticky Notes Crash Not Solved by SFC Vista does not show External Hard Drive connected through USB USB 2 0 TO IDE system is in full meltdown and I m not far behind System freezes or stops working unexpectedly Cannot open or close program including Task Manager the filtering on my 2007 excel does not work properly the filter count is incorrect often and the pull down filter box does not show all possible values in the given row Task Manager not responding to command to come up on screen Transcend Information 160GB StoreJet External Hard Drive WINDOWS 7 COULDNOT OPEN Version Of This File Is Not Compatible With The Version Of Windows You re Running Turned off Paging Files and Turned on Ready boost Not enough memory What does it mean when I click on something and nothing happens like copy and paste VerifyError Error 1014 Class Plugin could not be found when trying to play a swf file on Media Player Lite v03 3 0 4236 Unable to install Skype error SkypeSetup exe is not a vaild Win32 application Vista Cascade of problems ending in Safe Mode Cannot make changes necessary to get out of Safe Mode the web page could not be saved to the selected location When closing a Word Document This file is in use by another application or user Toshiba C660D vs Blue screen DRIVER IRQL NOT LESS OR EQUAL,My internet browser home page opens my e mail inbox How can I have it not log me in automatically so that others can sign in itunes downloads but will not install MY COMPUTER WON T BOOT UP NOT EVEN WHEN TRYING TO PUT IT IN SAFE MODE JUST GOES TO A BLACK SCREEN PLEASE HELP ME msn butterfly software not compatible my wireless router will not communicate with my computor My E Mails are not sending logitech gamepad UF13A not detected while trying to play games My ps3mediaserver program will not open up after I installed it any advice Microsoft Update Error Error message The website has encountered a problem and cannot display the page my wifi stopped working suddenly it is not showing available networks however other iphone is able to connect to router Please help Non commercial use notification for Office 2007 Professional Plus Network Connectivity not available at login Mail merge labels in 2010 not lining up with labels when printing no sound missing graphics Cannot play games on Facebook or anywhere else My office documents have got corrupted I can not utilize all the tools What should I do,1053 printer spooler error in Windows 7 A problem caused RealPlay exe to stop interacting with Windows Cannot download iTunes on Windows Vista Home Premium Blue screen stop errors after installing Windows 7 on a desktop computer Can I reinstall Microsoft Virtual WiFi Miniport Adapter on Windows 7 x64 Home Premium Brand new Gateway laptop with Windows 7 not charging when plugged in Can only run Firefox Internet Explorer and Chrome won t connect Windows Firewall issue Can I run my Microsoft Works Data base Version 8 5 in Windows 7 Home Premium or any Windows 7 13 Windows 7 updates repeatedly failing receiving error message 800B0100 and 8007065E Complete System Restore After Upgrading From Windows Vista to Windows 7 32 bit Can we create Windows 8 1 installation media from a computer running Windows XP Dell Latitude laptop running Windows 7 freezes after booting up BSOD on Windows 7 Professional x64 Display driver has stopped responding and has recovered Display driver NVIDIA compatible Windows Vista Kernel Mode Driver Version 179 67 stopped responding and has successfully recovered Crashing after upgrading to Windows 8 1 from 8 Display port DP and HDMI sync issues and problem with display profiles in Windows 7
Read More: [Solved] text after insert,How to Resolve - SHARE Charm works differently on "Win 7" side...?,[Anwsered] how can i access my msn account? I have had my email and password for years and now I can't get into it! Why? i am finding no help from windows live,How to Resolve - how to use sort, to sort a new list from th,shut down and other associated options in the start menu in win7 stopped working Tech Support,Acer laptop running Windows 7 shows "2.93 GB useable" but has 4GB installed,Downgrade from ie 10 on Windows 7 64 bit leaves no internet explorer,dns server search order failed 220.127.116.11 how do fix preblom?,Unable to install an application in windows 7 which was working on xp.,Page number format change