The client is a man of few words and has not requested a meeting or sent any questions. He said he wants results, but he does not understand what he wants.
Thank you
CLIENT gave ME A set of 10 text files with ambiguous data and no field descriptions, I uploaded them and discovered that each converted file had a repeating foreign key but no primary key. The task was to join these files together.
I proposed two solutions:
1. Linking all foreign...
Hello friends;
I'm using this code to search in Excel Table and display the result in LISTBOX On USERFORM
but I think this code is complex
do you have another code?
Can you suggest an easier code?
Private Sub TextBox1_Change()
Dim Data, Arr, Crit As String
Crit = TextBox1
With...
I have 2 Tables in attached DB
Imported
And
AllDataSource
I want to create query append data from Table Imported to AllDataSource but if the the record is exist in AllDataSource Update the record in All Data Source Table
1- Append Data from Imported Table To AllDataSource
2- if record exists...
Thanks for help
My goal is to extract incorrectly entered dates. I found dates with a value of 0:0:0. I couldn't filter them out, so I couldn't extract them to correct them. I suggested that I convert them to numbers, which would allow me to quickly find the errors.
Please explain to me if it is possible if I want to check a date after converting it to Double format
between Min(Double) AND Max (Double)
please mention
What is Min smallest date in Double format
What is the largest date in Double format
so I can extract the incorrect dates if I use this...
I investigated the date field and found an unexpected value. It might be the cause, because when I created a new table with correct dates, the Year function worked. This incorrect value is the result of incorrect input for many rows, such as:
Empty values
Only hours and minutes
Thank you all...
First Query
SELECT Year([MyDate]) AS YearfromDate
FROM TransactionTable;
Second Query
SELECT Query1.YearfromDate
FROM Query1
GROUP BY Query1.YearfromDate;
Why does this error appear
Invalid procedure call
When run query 2
and what is the solution
Thank you so much
SELECT
[city],
[HR],
[IT]
FROM (
SELECT
[city],
[department],
sum([salary]) as Salary
FROM dbo.emp
GROUP BY [city],[department]
) AS myData
PIVOT (
sum(myData.[Salary])
FOR myData.department IN ([HR], [IT])
) AS mypivot
the result (y)
Hello
SQL SERVER not access
Table Structure
/
employee name
Department
Salary
City
the table will be full of data
------------------------------
Pivot Table Result will be like this:
department Alabama Arkansas Georgia
IT 100000...
Here is the last edit
after editing
Sub Macro3465656565665465()
' Add Power Query to the MyTable table in the MyDatabase sheet
Dim powerQuery As Object
Set powerQuery = Application.Workbooks(ActiveWorkbook.Name).Sheets("MyDatabase").ListObjects("MyTable").QueryTable...
Here is the macro convert Power Query To Table
Here is the Problem
Need to append to existing Table
Sub Macro3465656565665465()
'
' Macro3465656565665465 Macro
'
'
With ActiveSheet.ListObjects.Add(SourceType:=0, Source:= _
"OLEDB;Provider=Microsoft.Mashup.OleDb.1;Data...