Search results

V, I do have a question though. I want to add fields to your final report from the original Tables, but the report seems to be generated in some unique way as the Design View doesn't even show the data fields and when I add a data field it doesn't preview correctly. Do you recommend a way to...

V, Have finally had a chance to go through your fine work in some detail and it is a bit over my head (for now). For example mdlPrepSource is a mystery to me. But obviously you have done what others could not do and so for my first attempt to use it I will paste my latest data into the original...

WHOA! This looks amazing. Will take me some time to understand it though. Thanks so much for getting back to me!!!

Hello, I am trying to group a subreport field SID (integers) to a Main report field UID (integers) so they line up next to each other in the final report. They are not primary keys b/c their ID numbers are not unique. There are many more main report entries than subreport entries, but I still...

Hi Vba Net, Your idea of temporary tables could work fine for me. Let me know if you think it's possible to get the effect I'm looking for. ThanKs

Thanks for taking the time to look at this. These Tables are the result of queries of much larger Tables which are probably normalized because they are maintained by people much more knowledgeable than I. One is a BEFORE Table and one an AFTER Table. They are based on unmatched...

vbaInet If you would have a look, that would be great. I am attaching a sample to this post. Here is the UNION Query I created that doesn't quite work: SELECT [Q_W-O_Match_Desc_ID].UID, [Q_W-O_Match_Desc_ID].SGNH_Hra_Main_Street, [Q_W-O_Match_Desc_ID].SGNH_Hra_From_Street...

Thanks for your reply. I have been able to do the Full Join with the SQL UNION query, but Access doesn't seem able to leave the Table_OLD or Table_NEW Sign Description fields blank when there are fewer entries on the OLD or NEW fields. For example, when there are more on the OLD side it...

Hello, I have been told what I want to do cannot be done with Tables. Now I am wondering if it can be done in a report. I am trying to combine 2 Tables along a common field ID, but there are several issues. Each ID represents a city block and on each block there are many traffic signs...

No matter. I'm going to go to town with your Unique ID procedure. I'll give blocks an ID and the sign descriptions IDs (for quicker recognition), and have 2 Tables open side-by-side, when necessary. Thanks again for all your help.Hope you can stick around and help others as much.

Texan, Thanks for getting me out of that quagmire. I was able to update and the IDs were unique and matching. Very cool. Only thing though, I don't think I explained myself well. As you have guessed I don't speak the language well. When I did a join of the ID fields, the result was Access...

Just a join? Finally something that I can do well. I wonder if you could clarify your Driver Table instructions. I can manage the UNION SELECT on the 2 Tables. I get the unique rows just fine. I can manage a SINGLE SELECT on 1 Table and APPEND it to the DRIVER Table which also gives me unique...

Thanks so much for bringing me so far along in this quest. This was more complicated than I anticipated and I am grateful you took the time to help.Your latest steps do have me stumped for the moment, but I will be going over them in the next few days. I do have one further question. I still...

Hi Texan, What I forgot to mention was the blocks are consistent in my two sub-Tables (for comparison) because they are based on the ORDER # field which is unique for each block. Unfortunately, these order numbers do not have any location indentifiers in them. They change completely with each...

What I am more modestly aiming for now, in the case of my short-term comparisons, is the IDS can work w/out a Master Table. I sort out the blocks that have updates in the latest Table. Then I search those same blocks from the previous Table and make two smaller tables to compare. I give them...

Texan, The MAIN STREET, FROM STREET, TO STREET, SIDE OF STREET, SIGN DESCRIPTIONS are almost completely uniform. They are so uniform, they are archaic sometimes (not reflecting a street name change). The Unique IDs you created will be the same, especially because I am comparing the Sign...

Hi again, Texan To answer your question, I would like to be able to "link" the Unique IDs (or blocks) of an OLD Table and a NEW Table so that I can see the Sign Description (or Signs) fields next to each other for easy comparison. Very often the changes to the signs on a block are...

Damn, that is so beautiful to behold! I believe you have saved me many, many hours. And you explain it so patiently! Thank you!!! May I ask one more favor? Because you have designed this technique, I have to ask, when I compare the OLD Table to the NEW, there will be some UNIQUE IDs that have...

Because my ulterior motive is, I ultimately want to compare all the Sign Descriptions (hence signs) from an OLD Table to a NEW one. There are many Signs (and Sign Descriptions) for each block (with the same MAIN, FROM, TO, & SOS fields), so those 4 fields repeat anywhere from 2 to 30 times (a...

OK, first I want to thank both you guys for looking at my problem. Dad, I was unable to get your query to work but that probably has more to do with my inexperience than anything else. Texan in Paris, you are right on the path. That Table of 71 unique names (across the 4 fields) looked perfect...