Recent content by TheGhostOfRain

Doc Man You certainly covered all bases. Well written. ;)

a,b,c,d should all be declared the same as rst and db. What does b do with its new value. move the a= rst.RecordCount to after the "End With" after With rst add a .MoveFirst before the MoveLast. Totally Untested.

Isn't "Data Sheet" mode a Design Mode where you can do anything. Try using Continuous mode instead.

Is this thread solved

Are you sure? Anyway, create an SQL in a query. Once that is working you can convert.

Try doing this in a query. Use the Query grid to build your calculation. If you can't do that then post a much cut down version of your database.

It may be a bit difficult this time, but if you can explain what you did it my help someone else. Good to hear you are happy with your progress.

Wendor Are you going to post a cut down version of your Data Base. It would help us to see the problem more clearly. I am sure you must have a good reason for not posting if that is the way you want to go.

I believe that you should have all your relationships in place. This will allow you to see a map of what is happening. If you can't join the tables, it may be because the design of your tables is incorrect. "it start showing me wrong values " This makes me feel that you do have some incorrect...

Can you show a diagram of your relationships.