Go Back   Access World Forums > Microsoft Access Discussion > Queries

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-27-2006, 05:15 AM   #1
Wminnette
Guest
 
Posts: n/a
Question Devious Query

Hello! Thanks for your help.

I am using Access 2003 and I am using a make table that is querying some tables and a select query. The select query by itself returns the correct result, but when I query it from the larger query, the Bonus field is blank.

I tried changing the select query to a make table query so I could use the table in the larger query. However, although the smaller make table query again returns the correct information in Datasheet View, when I make the table the Bonus field is blank again.

I don't get any error messages, just a blank field. I couldn't find any documentation on this anywhere. BTW, I am using ODBC to pull data from Oracle tables into Access to run these queries. I don't know if that matters.

Lastly, I am posting the code below. Thanks again for your help.

SELECT DEALER_BONUS.DEALER_ID, DEALER_BONUS.BONUS
FROM CUR_CERT INNER JOIN DEALER_BONUS ON CUR_CERT.CERT_PERIOD_ID = DEALER_BONUS.CERT_PERIOD_ID;

  Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding a Auto increment Text/Number elliotth123 Tables 13 05-17-2013 08:30 AM
Pulling data from several identical tables and returning the results to one big query morlan Queries 5 01-23-2007 05:17 AM
Query by Form (w/Date & Memo fields) esskaykay Modules & VBA 5 12-30-2003 02:38 PM
Query for a report morlan Queries 1 11-16-2003 10:06 PM
Help returning blank (no entry) records with a parameter query rgsmpx Queries 2 10-09-2001 09:04 AM




All times are GMT -8. The time now is 05:43 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World