Recent content by r621

Hello Plog, I shall have a single record because I need to import that format in program for automatic drawing

Dears , I need one time again your help, I've a table as following: TAGNo INSTRUMENT TYPE Sh 99-PP-3001 ALARM 33 99-PP-3002 ALARM 33 99-PP-3003 ALARM 33 99-PP-3004 ALARM 33 99-PP-3005 ALARM 33 99-PP-3006 ALARM 33 99-PP-3007 ALARM 33 99-PP-3008 ALARM 33 I need to combine all...

thanks Pat , basically I want hide to my colleagues all queries and show them only a form where perform actions

sorry I didn't get the point...

Hello To everybody, I need your help: On access startup is it possible to show only a form and lock it with password so as not to show queries and tables? I'm only interested in the user using the form without knowing what's underneath.

Thanks a lot arnelgp!

Hello jdraw, I need to insert records 18 and 19 for the Address_T 3,6,9 etc. every 3 address I need to insert record 18 and 19

Hello to everybody, I need a little support about my db that I've created, basically I use it in order to generate script for Autocad for automated drawings, my concern is about the following matter: With a Query (name : LOOP SCR_2) , after SCR_SEQ 17 I need to insert additional records...

Sorry I didn't got the point...

Dears, I've solved my matter as I told you , but for curiosity I've tried also wit this code: select T1.*, T2.* from (select * from InputT where TAG = 'A') as T1 inner join (select * from InputT where TAG = 'B') as T2 ON T2.X = T1.X; But this query is returning a popup...

Hello , sorry for the delay of the responde but I was out, Yes I solved with query of EBS in post #5 very useful also the demo of post #6 of arnelgp. Thanks to all for your support, really appreciate! In not so familiar with database and SQL , I've just start to follow online tutorial and...

I think ON the final query i guess that some code is missing.....

This sql code will work also in MS access?

Yes basically this is what I need, but I need data divided per tag name as per second table in my first post

This query will concatenate all xx-xxx-A and xx-xxx-B in the same records, is it correct? I need to concatenate in the same record the tag with the eguale first part of e.g. AA-321-A and AA-321-B ... I have a lots of different tags with the same philosophy in ny table...