Search results

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

(y) (y) (y)(y)(y)(y)

Here is the DB the error still there after removing blanks and hours and minutes and checking the date using VBA CODE

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

When adding a groupby to query1 same error appears

The trusted location is ok Macro enabled The immediate window is work

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

how can I show show queries by vba show queries list (Properties) Navigation

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

(y) (y) (y) (y) (y)

Excel Power Query Excel Table Not Access

:( not work need alot of research from my side I need to load Power query to special Excel Table by VBA

(y)

How to add power query to specific table by code I failed on all my tries Thanks

how can I delete one of my posts Thanks

:unsure: :unsure: :unsure: :unsure: Is this the correct input Decimal (4,2) = storage will be 5 bytes