Conditional Macro or else????

[jane30]

Hi, there!

I have an Autoexec macro, run once a month, which automatically imports monthly data to TABLE All in DB1. I plan to have a further step: based on the value of field Per in TABLE ALL, automatically export the data to an approriate table in another database DB2. That means, If field Per="01", export data to table01 in DB2; field Per="02", export to table02; and so on. So, at the end of year, I should have 12 tables in DB2. I tried to use CONDITIONAL MACRO. But it seems that conditional macro only works with the control on a form or report. It doesn't work with the field value in a table. I might be wrong. Please correct me.

Thanks a bunch in advance.

 

[tlbroadbent]

It would be very easy to do what you want in VB code. Have you considered writing a VB module? Terry L. Broadbent
Life would be easier if I had the source code. -Anonymous