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

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? :)
 
M

Michel Walsh

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
 
A

Andrea

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
 
M

Michel Walsh

Hi,


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



Vanderghast, Access MVP
 
Top