Query dilemma

[BabyATX13 via AccessMonster.com]

I have 2 queries, one to append data and the other to delete data, they both
use the same parameter (<=[Enter End Date]) I run a macro that combines the 2
functions in one step, how can I get this parameter to only show up one time
instead of twice?

Any help would be appreciated.
Thank You,
K Board

 

[John Vinson]

I have 2 queries, one to append data and the other to delete data, they both
use the same parameter (<=[Enter End Date]) I run a macro that combines the 2
functions in one step, how can I get this parameter to only show up one time
instead of twice?

The simplest way would be to use a Form (frmCrit let's call it) with a
textbox (txtEndDate) on it. Use a criterion

<= [Forms]![frmCrit]![txtEndDate]

instead of your current parameter; put a command button on frmCrit
with your macro name in its Click event to actually run the queries.

John W. Vinson[MVP]

 

[BabyATX13 via AccessMonster.com]

Thank you John that works great. I had a feeling I was going to have to
create a form for that.
Thanks again
K Board

I have 2 queries, one to append data and the other to delete data, they both
use the same parameter (<=[Enter End Date]) I run a macro that combines the 2
functions in one step, how can I get this parameter to only show up one time
instead of twice?

The simplest way would be to use a Form (frmCrit let's call it) with a
textbox (txtEndDate) on it. Use a criterion

<= [Forms]![frmCrit]![txtEndDate]

instead of your current parameter; put a command button on frmCrit
with your macro name in its Click event to actually run the queries.

John W. Vinson[MVP]