i am inserted a cross tab in my report .i calculate the total of weaklly sale in the cross tab.now i want to calculate the amount in rupees and the percentage of sale. how can i calcuate it
You are close but I need to exsplain myself some more. I have the above already(yours is cleaner) and it will work for the first row. Think of it this way. You have a a grid of 18 rows and 20 colums. You can use the above code for the first row but you can't use it for the second, the form names...
I have a form that has 20 rows of fields.
In each row there is 18 fields
When they save a record I would like it to update a table. Did I mention all of this is unbound? I would like to create an update event that would work with a loop and a counter.
In the first row, first field = row1field1...
I just tried that and it errored out.
Varx2 = Me!Record & " " & Loopcount & " " & Text1
It said that It could not find Record (Me!record).
What I have is a long list of fields on my form called
record1text1
record2text1
record3text1
...
record80text1
And I don't want to...
Need help with the following. I am trying to make a loop and make it add record1, record2… to 8. It counts fine but it is having issues (like me) updating a DB. I need help with correct syntax.
Do While not loopcount < 9
Varx1 = “rst.Record” & loopcount & “text1”
Varx2 = “Me!Record” &...
Need help with the following. I am trying to make a loop and make it add record1, record2… to 8. It counts fine but it is having issues (like me) updating a DB. I need help with correct syntax.
Do While not loopcount < 9
Varx1 = “rst.Record” & loopcount & “text1”
Varx2 = “Me!Record” &...
Need help with the following. I am trying to make a loop and make it add record1, record2… to 8. It counts fine but it is having issues (like me) updating a DB. I need help with correct syntax.
Do While not loopcount < 9
Varx1 = “rst.Record” & loopcount & “text1”
Varx2 = “Me!Record” &...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.