can someone please tell me or show me a GOOD example of how to use recordsets properly. thanks in advance

What do you want to do with a recordset?

i need the query to ignore something if there if it isnt there in a table.

i need to calculate the amount of income, from three different tables, sales, bills and membership fees.

i always have bills and sales, for every month, but sometimes i dont have any membership fees. When i run the query, that i am currently using,it works fine until, i run it for a month when there were no membership fees, in which case it just doesnt show anything.

I dont know much about recordsets but i've been told that they can solve this problem.

If you have any suggestions, i would be very grateful if you can share them with me. Thanks in advance.

Update queries are more efficient than code loops that process recordsets. Try changing the joins in your query to "left Joins". That will produce a recordset (queries produce recordsets) where all the rows of tblA are returned along with any matching rows from tblB.