Search results

Thank you, now is clear. Just a minor modification in the TRANSFORM query, should be like: TRANSFORM Min(Switch([CrosstabHeading]="BeginDate",[STARTING_DATE],[CrosstabHeading]="EndDate",[ENDING_DATE],1,[Owner])) AS Expr2 SELECT qselSubSystems.Subsystem FROM qselSubSystems, tblCrosstabHeading...

As i specified in my post, I exactly followed what DHookom suggested (post 11). In the same post (before post 13) it was mentioned that "If you want a particular order to the columns, I would use a little VBA to modify the SQL of the crosstab to set the crosstab headings based on the max seq...

No need, thanks anyway, i tried to build VBA myself using the SQL you suggested as result (i named "FinalResult"). This is the VBA which will create the final query (FinalResult_rc) I need with values in correct header order: Cheers.

Yes, this is perfect, thank you. Yes, I need the order of the header as below so I would appreciate If you can show me the little VBA you are talking about to obtain it: Cheers.

Hello, they added now another column, the Owner. So each StartDate and EndDate is refer to a owner (see below): And the result should be the follow: I tried to update the PIVOT sentence in the Transform queries, but it does not work (maybe I'm not able enough) could you kindly suggest me...

Thank you all, really appreciate your kindly support. I will give answer to all of you below: To CJ_London : The query, output of the code you provide, it works, and it is exactly what I need in term of query. Then, since my final scope is to have a "physical" query, I will modify the code...

Thanks a lot, first of all. Ok I build the Q1 and Q2 and is clear and work fine. Now, the combined query should be dynamic, not manually because records may change (i.e. more start/end date) so how to write the combined query which will work dynamically in case of record change? Not sure i'm...

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