count query

[ailyn]

I know this might sound stupid but I really can't find it anywhere. How do you count how many times a query is run.

I need to make a DoCmd.RunSQL stringname and count it so that I can loop it to match a certain number. Is that possible?

 

[Wicksa]

ummm I'm no genius and really dont have a clue so dont lidten to me but...

couldnt you have your query +1 to a table and look at that table each time in the loop to check if its the number you want? probably not but sounds logical to me lol

 

[allan57]

Ailyn, I think this is what your after

Dim IntLoopCounter as integer

for intLoopCounter = 1 to 5 ' run the query x5
docmd.runsql "Your Sql statement here"
next intLoopCounter