Quey Bug??? .... or is it just me

  • Thread starter Thread starter Andrea
  • Start date Start date
A

Andrea

Here is a simple query that should match
Buy.ID with Sell.BuyID

SELECT Buy.ID, Sell.ID, Sell.BuyID
FROM Buy INNER JOIN Sell ON Buy.ID = Sell.BuyID;

But here is the result:

Buy.ID Sell.ID Sell.BuyID
3 3 15
4 4 16
5 5 17

IT ACTUALLY MATCHED Buy.ID WITH Sell.ID!!!!!

How is this possible?

Any idea is welcome, or should I just trash Microsoft
products? :-)
 
Hi,

Well, it is not reproducible here, and I doubt it is the case for anyone
else too... :-)

You are not using lookup "data type", aren't you? I mean, if you use those
lookup (data type), you get displayed, in some context, not the real value
but the looked-up value, and often, that leads to similar "result" for
someone who is not fully aware of that feature (that you are not *obliged*
to use :-) ).



Hoping it may help,
Vanderghast, Access MVP
 
Yeah,
you're right... :-)
the data shown was the result of the query, not the
actual data, I noticed that only when I did a data access
page that showed the real data.
I guess it's a great feature...just a little dangerous
for stupid users like me! :-)
Thanks again,
Andrea
 
Hi,


"unaware", not stupid ... there is a big difference, the first, is
generally a temporary state :-)



Vanderghast, Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subquery not integrating to query to display previous sum of quantities 3
Query on two tables with matching null fields 4
Select Max, return unwanted rows. 4
Can inner join be done on queries? 8
query to get top player 8
How to combine queries???? 2
Using InStr Access 2007 0
how to use where clause in my query 5

Back
Top