hvis man nu har 4 afkrysningsfelter 1 montering = 60 % 2 lednings mærkning 20 3 komponet tagging 10 4 kabelnummer 10 kan man så lave det så den post i tabellen bliver grøn og den i status feltet skriver det antal procent som man nu er færdige til
I think you need to explain in a bit more detail ;-)
"kan man så lave det så den post i tabellen bliver grøn og den i status feltet skriver det antal procent som man nu er færdige til "
Its not possible to give a colour to a record in a table, but its possible to give a row in a form a colour using conditional formatting, but you need to be more specific as to when it gets a specific colour...
I have made a simple example which has the four "afkrysningsfelter" in a table.
On a form there are the four "afkrysningsfelter" and a status field. The form is based on a query which has a calculated field for statu which gets its value from calling a function which calculates the value of status from the status of each of the "afkrysningsfelter".
Then on the form there is a conditional format on the status field and if it is 100 then the field is green.
Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.