Search results

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...

Basically I'm working with MS ACCESS, I've a DB which contains the device's TAGs, some devices can have associate two tags, A and B, I need to combine the two records into a single, for two reasons: 1) I need to create a single Report in MS Access with the data of the both records A & B 2) I...

Hi Guys, I need your help , I'm trying to combine two records in a single record, I've tried without results to use a crosstab query. e.g. : Following a sample of the table : TAG DESCRIPTION FIELD 1 FIELD 2 FIELD 3 FIELD 4 AA-321A TEST1 1 2 3 4 AA-321B TEST2 5 6 7 8 AA-322A TEST3 9 10...

thanks Pat I got the point , Just I don't understand what do you mean take the First () valute, could you please make a sample? Ok Finally Got It thanks for your support :)

Is exactly what I want thank you very much Arnelgp! But I've a last question : Suppose that I've a table like this: Tabella3 Tabella3 ID Tag_Number Junction Box Multicable Tag Terminal_Number__Name_ 1 18-DFIU-001 18-JG-017 18-MG-017 1 2 18-DFIU-001 18-JG-017 18-MG-017 2 3...

I'm sorry all multicables are 18-MG-017 is a mistake JG. Tabella3 Tabella3 ID Tag_Number Junction Box Multicable Tag Terminal_Number__Name_ 1 18-DFIU-001 18-JG-017 18-MG-017 1 2 18-DFIU-001 18-JG-017 18-MG-017 2 3 18-DFIU-001 18-JG-017 18-MG-017 3 Query result shall be ID Junction...