Recent content by enu1978

i figured it out. thanks

you know i've been working with that selection also and i keep getting an runtime error data type mismatch. this is getting so frustrated, were you able to figure out anything John or ANYBODY!!! THANKS

OK John, So i tried a new method or can you say new coding because i found the other coding just to darn confusing. The new coding is simple enough and it did get my field to cocatenate:) but now the new field repeats over and over again :mad:. For example instead of just 40219000, 12458796...

Thanks John for responding, Now let me explain my database. The two tables are REPLACEMENT and BACKORDERS. The data in the databases are just a sample of data taking from the actual larger tables. The field ITEM_NO number criteria has been specified to that 40192700 number. In the actual larger...

ok John i hope youre still there so I was looking at the blue claw website and i found a code that i think might work for me it's the first code relating to the patient ID. I modeled my code exactly to theirs but i'm missing something. I'm very new to this coding thing so i'm hoping someone can...

Thank you i will look through the links and if i have questions i hope you're around to answer me. thanks agaiin for welcoming me.

I'm having trouble with cancatenation with two tables. Ok I have two tables 1 table is called backorders the other is called replacement table. When i join the tables by Item No and I query the tables my output is what you see below it duplicates because REPL_ITEM can have two items in the field...