PC Review


Reply
Thread Tools Rate Thread

Creating a Access Report from SQL

 
 
Kevin Harper
Guest
Posts: n/a
 
      17th May 2011
I have an SQL that I need to turn the following into an
Access Report. I am trying to get it to referance the names (last, first) against the Patinet ID #. The following I was able to get in SQL but can not figure the way to pull it into Access.

select t.test_performed, t.patient_id, t.patient_lastname, t.patient_firstname from test_table as t where exists (select * from patient_table as p where t.test_owner = p.patient_tag and (t.patient_lastname != p.patient_lastname or t.patient_firstname != p.patient_firstname))

The following is what I have so far. However I can figure hoe to write it out to cross reference them...

("n",[TEST_PATIENT_LASTNAME],[PATIENT_PATIENT_LASTNAME])
("n",[TEST_PATIENT_FIRSTNAME],[PATIENT_PATIENT_FIRSTNAME])
("n",[ TEST_PATIENT _ID],[PATIENT_PATIENT_ID])




 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
creating a label report in access =?Utf-8?B?TWVsaXNzYQ==?= Microsoft Access Reports 27 13th Dec 2008 04:09 AM
creating a report with Access Joe Microsoft Access 1 29th Sep 2008 06:57 PM
creating report in access cliff Microsoft Access Database Table Design 1 19th May 2008 09:42 PM
Need help creating a report in access Deevusone Microsoft Access Getting Started 2 19th Feb 2008 12:33 PM
Help with creating an Access Report =?Utf-8?B?TGlzYUs=?= Microsoft Access Reports 1 1st Mar 2006 10:31 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 05:48 AM.