sum values ​​with condition

[andy49]

Thanks Steve. Basic error!!


Sent from my iPhone using Tapatalk

[g.adamo@email.it]

sorry friends i have to tell you that i'm working with accss 2010 . I hope that's not the problem but if i try to upload a new tbltilt
the message yet appears:

errore di run time '3144':
errore di sintassi nell'espressione UPDATE


so if I press the debug button it appears:

sqlstring = "UPDATE tbltilt_full SET tbltilt_full.[values] =" & updateval & " WHERE (([tbltilt_full].[code]=" & Chr(34) & rs.Fields("code") & Chr(34) & "));"

CurrentDb.Execute (sqlstring) is highlited in yellow

rs.MoveNext
i = i + 1
Loop

[andy49]

Did you use my updated version when you uploaded a new version.




Sent from my iPhone using Tapatalk

[g.adamo@email.it]

I imported a new table and I have overwritten the existing one.
Then I opened the mask. I set it the number of systems and the number of tilt.
I pressed the first button, and everything went well.
I pressed the second and popped the error.
looking at the query it is seen that the codes have been generated for null fields but also that the numerical values ​​do not appear.
I am attaching your file with the new table

[andy49]

Have you changed your system names?

they've gone from a,b,c to s and c?

It would help to know what the system letters are gonna be

[andy49]

The highlighted line assumed the systems were a to z as your initial messages suggested. If you want to change the list (as I've done as you have given systems s and c) then you can make any changes.

Private Sub Command6_Click()
Dim alphabet As String
Dim numbers As Variant
Dim db As Database
Set db = CurrentDb
Dim mysql As String
DoCmd.SetWarnings False
DoCmd.RunSQL "DELETE * FROM tbltilt_full"
DoCmd.SetWarnings True
alphabet = "scabcdefghijklmnopqrstuvwxyz" 'systems available

[g.adamo@email.it]

system could be a name like mike1 or a single letter like b , a c but often a name

[andy49]

Ok leave it with me. I'm assuming your imported file will always have all the system names on there


Sent from my iPhone using Tapatalk

[andy49]

sumvalueswithcondition - Copy1111.zip

How's this?

I've adjusted the code above to extract how many systems you have (from your download) and what they are called

Andy

[g.adamo@email.it]

the same error appears if i import a new table.
it'll be most simple if i tell you that the name of systems are not important?to the end i have to sum valus of system each checkpoint and each tilt with the condition that there aren't null contribute so if for any checkpoint and tilt one of the system doesn't have values i have to consider, for that system, his first not null or the last not null.
to the end I need
chekpoint , tilt, sumwithcondition of system values.
now I'm attaching a realistic input table that I have to use.
I'm asking your help becouse I need an application that became me able to repeat the operation with more than one input table (everytime different number of checkpoint,of system,of tilt but the same condition ever)
I'm sending some types of tables i have to use

[andy49]

sumvalueswithcondition.zip

Can you do a test run on this?

[g.adamo@email.it]

when i try with another table the error message yet appears

[andy49]

when i try with another table the error message yet appears

Can you send me a screen shot of the table tbltiltfull please

Or even better

Can you run a query on tbltiltfull returning null and zero values?

[g.adamo@email.it]

test 1)
I imported a new table tbltilt, I opened the form1 and I pressed button 1 ok. I pressed button 2 and the message erroe appeared. see attached file to see tbltiltfull
test 2)
I imported a new table tbltilt, I cancelled all records on tbltiltfull, I opened form1 but it was white page . see attached file

on test 1 e 2
I imported a new table gsm. I copied the recordset of gsm and I put these on tbltilt

[andy49]

sumvalueswithcondition2.zip


See if this version runs



Should this fail on an error, can you debug and copy the update statement in the immediate window which has the largest number at the beginning.

Then copy and paste it back on here