Run same query "x" times

[rogerarce]

Hi all.
I need to know how I can run a query as many times as I need. Let's say I have a form where I have the following
fields:
[employee][timesabscent][cost]
I would need to run the query all times as [timesabscent] shows. Is this possible?

Thanks for your help.

Roger Arce

 

[PCLewis]

I am sure you know how to run a command in VBA multiple times so I think you are asking how to run a query from VBA.

One way is DoCmd.RunSQL wher eyou copy/paset the query form the query builder SQL section

Another way is along the lines of:
currentdb.QueryDefs("Query1").Execute (assuming the query is not a simple select query).