Search results

Hello everyone, i have the following problematic and i would like to know if someone can propose a solution either with a query or even with vba. I have the following table: and what i need as output is the following? In few words i should have a new table (query) which return for each Key...

Good morning, i was doing some test and i got error 3077 - Syntax Error (missing operator) at the following point: .FindFirst "[MANUFACTURER]='" & sEquipt & "' AND " & _ "[MODEL_NUMBER]='" & sModel & "' AND " & _ "[TECHNICAL_OBJECT_TYPE]='" & sType & "' AND " &...

Thank you but as i mentioned above i can't add any index since that is a view table in Oracle. Will find another way even if already now is more or less ok.

e Excellent! Thank you for kindly support. Cheers.

Good morning. Yes this work excellent, thanks. Little bit slow but because my Table2 is really big but i will try to find a solution to speed-up the process. I have another question if you don't mind: there are Value which should not give errors (so should not appear) because the difference is...

My Table_2 is an ORACLE view table which is linked to my DB and i don't have any right to modify the structure. No else i can think to do a local copy because is huge table.

I used it but when i run the query i got Runtime error 3219 - Invalid Operation at the line : Set rs = CurrentDb.OpenRecordset("SAPRAMZ_V_IMPORTAL_EQUIPMENT_CATALOG", dbOpenTable) Then i try to change dbOpenTable with dbOpenDynaset and i got error Runtime error 3251 - Operation not supported...

Thank you. I followed exactly what you suggested with a small modification described at point 1: 1. Since i don't have an auto number primary key in my Table1, i create a temporary table of my Table1 (lets call Table1_Temp) adding all fields of Table1 and the field T1_ID as auto number and...

Good morning and thanks first of all. The demo is good but it consider only numbers while i need to control all records (either numbers or char or even date sometime) . Maybe my example confuse because it was just a case that differences was only in numbers. See below a more accurate example to...

Good afternoon everyone. I have the following question please, if you can support me. I have to create a query which return the differences in one field between 2 tables. I give the example hoping i'm clear: I have Table-1 as follow: EquiMan EquiModel number Object type Class Characteristic...

Hello everyone, first of all i would like to thanks all those give support on this tread, it really help me to manage the issue, sorry for late answer bit could not before. I would like to give some answer to some of you: To Pat: yes you are absolutely right, regardless i'm fighting to get...

Is a view from SAP , or better, is a view to a database which is mapped to SAP. I also sure they build this field, because it was a requirement and there is also another problem, the type of the each frequency field is "Long Text" hence not very usable (even in a possible crosstab query). Fully...

I partially agree on this, at certain point of the project and especially if you get the application from someone else, we need to understand the time required and if it is really convenient to do a change which may involve many others things and so goes in a loop of modification which hardly...

In that case, since I have only one frequency, the max will be itself.

Thanks for the answer. Sorry but i don't understand your first point: it seems to me I don't use any "Yes/No" field, also is too late in this moment to change the structure, anyway thanks for suggestion. Saying this, let's do in different way, i will manage the order later. How to get the...

Good morning everyone, I have the following case: This is my Original Table: TASK_LIST_GRP TASK_LIST_COUNTER W1 W2 W3 W8 M1 M2 M3 M4 Y1 OMBIRD 01 X OMBIRD 01 OMBIRD 02 X OMBIRSQ0 01 X OMBPCRQ1 01 X X...

Just to clarify the scope of all of this, maybe there is another solution: actually I'm forced to prepare a CSV template file because it is required by the SAP functional team who upload data into the system trough a program who read the CSV File. So, as i explained, i export my data from my ms...

Sorry, but i believe i don't understand you. This is the original query from the database, data are stored as it is showed. What do you mean when you say that are not consistent, format is the same, we speak about technical data which is normal are like that. Honestly i don't understand where is...

If it can help, following is my query result which I use to export in CSV with the following instruction: Docmd.TransferText acExportDelim, , "008_EQUI_Temp", myfilename, True The records which are wrongly transformed are in the column "ManufSerialNo" in red color, all the others are well...

Good morning everyone and thanks for all answer. Attached is part of my data who I usually export from MS ACCESS (trough query) in CSV. The problem is in the column "Q" (ManufSerialNo) for those 3 very long numbers. Cheers