Recent content by zezo2021

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

I'm trying to find another solution asap

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

(y) I solve the problem after viewing your post Can you check the DB? after the solution is applied and give a feedback

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

(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)