L
Lucy
Hi There,
I have a query that has 2 prompts, and I am trying to use the export wizard,
I
know that you have to set up parameters, and you need to type in the prompts
used in the query, as well as the data types. I have 2 prompts for dates, and
I have entered it as follows: "Semi-Monthly Date", with a data type of
"Date/Time" and another prompt, "Bi-Weekly Date" with a data type of
"Date/Time". Is this format correct, do I need to put parentheses around
these prompts, when defining it in the parameters? Because, when I try and
run the export, it says, "Too few parameters. Expected 2", and when I look it
up in the help, it says I need to define the parameters.
If anyone knows the solution to this error, it would be greatly appreciated
Many Thanks,
I have a query that has 2 prompts, and I am trying to use the export wizard,
I
know that you have to set up parameters, and you need to type in the prompts
used in the query, as well as the data types. I have 2 prompts for dates, and
I have entered it as follows: "Semi-Monthly Date", with a data type of
"Date/Time" and another prompt, "Bi-Weekly Date" with a data type of
"Date/Time". Is this format correct, do I need to put parentheses around
these prompts, when defining it in the parameters? Because, when I try and
run the export, it says, "Too few parameters. Expected 2", and when I look it
up in the help, it says I need to define the parameters.
If anyone knows the solution to this error, it would be greatly appreciated
Many Thanks,