Search results

thank you so much @plog it works very well

could i do this with two tables table1 for custID and invoice id table2 list of numbers between 1 and 500 so if table1 contains 200 invoice it will compare between the numbers from 1 to 200 or in another way i dont want to enter the customer ID in another table i want to make it work with...

cant get a result do you have a sample for this query thank you

thank you sir i will try it and get back with the result

hello guys, i have two tables table1 = customers info table2 = custom invoices table each customer will have invoices starting number 1 customer1 invoice 1 - 2 - 3 - 4 customer2 invoice 1 - 2 - 3 - 4 so now i have too much invoices i want to add to the system when i enter all the...

guys i don't why but i run the query after closing the form and now everything work i tested with many many records

when i set warning to true it works but after second run not from the first run any other solution to sum the data instead of make table query ??

SELECT tbl_Personal_Sanctions_02.PID, tbl_Personal_Sanctions_02.Sanction_Type, Sum(tbl_Personal_Sanctions_02.Sanction_Value) AS SumOfSanction_Value INTO tbl_Sum_Edbarat FROM tbl_Personal_Sanctions_02 GROUP BY tbl_Personal_Sanctions_02.PID, tbl_Personal_Sanctions_02.Sanction_Type HAVING...

so how to resolve this problem. am sure there is a way because it's impossible to let the user close the form and run the query manually

i have a make table query that i want to run it after adding new data DoCmd.Save DoCmd.SetWarnings False DoCmd.OpenQuery "qry_Sum_Edbarat" the new data will be saved the set warnings will be set to false but the make table query doesn't run, but if i double click on the query...

i changed to IIf([Sin01_Code] Is Not Null And [Sin02_Code] Is Not Null And [Sin03_Code] Is Not Null;[Sin01_Code] & " - " & [Sin02_Code] & " - " & [Sin03_Code];IIf([Sin01_Code] Is Not Null And [Sin02_Code] Is Not Null And [Sin03_Code] Is Null;[Sin01_Code] & " - " &...

i can't seperate with comma just with semicolon after adding empty string between the first two semicolon i get this error The expression you entered has a function containing the wrong number of arguments

hello guys, what's the problem with this expression IIf(IsEmpty([Sin01_Code]);;IIf(IsEmpty([Sin02_Code]);[Sin01_Code]);IIf(IsEmpty([Sin03_Code];[Sin01_Code] & " - " & [Sin02_Code];[Sin01_Code] & " - " & [Sin02_Code] & " - " & [Sin03_Code]))) am getting this error The expression you entered...

hello guys, i want to run an update query to update the last record in a table from multiple table N.B: each table from where i want to bring data contains just one field and one record this my code UPDATE tbl_Sanctions SET tbl_Sanctions.Code01_01Year = [tbl_01Years_Code01].[txt_Text]...

hello guys, i have a query that counts how many times the same record exist and i have table that i want to update the field on counter with the data from this query this is the query SELECT Count(tbl_Personal_Sanctions_02.Sanction_Date) AS txt_Numbers_Original FROM...

Thank you all And specially @CJ you rock man I appreciate all your help

Any help guys?? Thanks

Thank you it works very well but still need one thing plz this solution count the codes seperatly for example i want to sum the code 901 and code 105 or any two or three codes, should i make a new query or could we update this one ?

This is a sample data I have have multi-value field No need for special function because i just want ro fo back 365 or 730. I just want to go back by days

hello i have a table contains two fields first field = Date second Field = codes 01/01/2017 | 105, 201 05/03/2017 | 105, 901 01/01/2018 | 105, 201 07/08/2018 | 901,902 One Code i want to count the code 901 from today and one year back so i will get (1) 105 from today and five years back i...