Recent content by pablofonto

Yep, I actually already did use the update query to change all the blanks to "1" and once I got my final table I ran the update query again to make all thos fields NULL. I think this works out! thanks for your help and have a nice weekend! Pablo

Paul, do you think if I add a "1" to all the blank fields in the Subty as a workaround would be a good idea? I can change the query to be a make table query and delete all the "1" after. Please let me know what you think, this is getting to my nerves already. thanks, Pablo

Paul, I don't get it. How can when I open the table there lots of Subty that are blank? if they're not null, then what's their value? Sorry, if I'm making a stupid question, but I'm not an advance user. thanks for your time on this! Pablo

I forgot the file, here it is!

RuralGuy the dates for the two records were the same, so the criteria should met both records. I appreciate you guys trying to help me with this issue. Here I uploaded another table where some records with the NULL fields are also pulled in the query, you will also see why I have the join on the...

I see what PBALDY is saying, is probably something with that field being NULL. Now I don't understand what you RuralGuy are telling me. This thing is driving me crazy, because I thought about getting rid of the Subty join, but I needed for other things that I have in the table. I just didn't...

Hello Everyone, I've been trying to figure out why my query only pulls record Object ID 10011399 and not the other one, but I can't figure it out. Can anyone please help me see what's wrong? Thanks, Pablo

Is there a way to have those missing records show as well without compromising the other results? I would like these records to show as NEW INFO. I've never done anything this complicated in Access before and I'm not too familiar with SQL either, so I really appreciate all your help. thanks, Pablo

Peter I figured out why was not working and it's okay, the only thing I can't figure out why for Objec 10010754 the Sty A002, A011 and B012 don't show. They should be display on the new data column. I've attached the access file so you can see it. Thanks again for all your help! Pablofonto

Peter, it didn't do anything! Am I missing anything" SELECT [Activity Table4].Ob AS [Object type], [Activity Table4].ObjectID AS [Object ID], [Activity Table4].IT AS Infotype, [Activity Table4].Subty AS Sty, [Infotypes Desc].Description, [Activity Table4].[Changed on], [Activity Table4].[User...

Thank you! I will try this today and let you know. pablofonto

I need one more thing! Thanks to Peter's help my query is almost working as I needed it to. The query is now displaying the OLD info under the OLD Info column and the new under the New Info column which is what I wanted. Now what I need is to have New Info display under the New Info column even...

Thank you Peter, it worked great!! I also tried with more than 2 records per item and still worked! thanks for your help, P:)

Thank you Peter! I will try this today and let you know. There might be times that we get more than 2 records per item. Will that make a difference with this code? P

I have a table that mutliple info per Object and I would like to show in one row the old and new information per Object. Basically the row that has an "end date" of 12/31/9999 is the new info and the row with end date different than 12/31/9999 is the old info. I think this can be doen with a...