parameter prompt

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

have a crosstab query that runs off of a select query.
im trying to make the crosstab a parameter prompt by
doing between [from] and [to] but it gives me an error
message that the microsoft engine database does not
recognize can i not do a prompt with access 2002 like in
my old version?
 
have a crosstab query that runs off of a select query.
im trying to make the crosstab a parameter prompt by
doing between [from] and [to] but it gives me an error
message that the microsoft engine database does not
recognize can i not do a prompt with access 2002 like in
my old version?
Click to expand...

You can... but you must explicitly include the parameters in the
query's Parameters collection. Open the query in design view, and
select View... Parameters or rightclick the grey background and choose
Parameters. Put the [from] and [to] in the left column of the popup
box, and specify that they are of Date type.
 
i right clicked on parameters on the left side where it
says parameter what goes in there just the bracket
[From] and in the date type box put Date/time and then
below do i put [To] and next to that Date/time do i
need to use between and And ?
-----Original Message-----
have a crosstab query that runs off of a select query.
im trying to make the crosstab a parameter prompt by
doing between [from] and [to] but it gives me an error
message that the microsoft engine database does not
recognize can i not do a prompt with access 2002 like in
my old version?
Click to expand...

You can... but you must explicitly include the parameters in the
query's Parameters collection. Open the query in design view, and
select View... Parameters or rightclick the grey background and choose
Parameters. Put the [from] and [to] in the left column of the popup
box, and specify that they are of Date type.


.
Click to expand...
 
You DEFINE the parameters as you have.

THEN you use the defined parameters in your criteria as you have in the past

Field: SomeDateField
WHERE: Between [From] and [To]
i right clicked on parameters on the left side where it
says parameter what goes in there just the bracket
[From] and in the date type box put Date/time and then
below do i put [To] and next to that Date/time do i
need to use between and And ?
-----Original Message-----
have a crosstab query that runs off of a select query.
im trying to make the crosstab a parameter prompt by
doing between [from] and [to] but it gives me an error
message that the microsoft engine database does not
recognize can i not do a prompt with access 2002 like in
my old version?
Click to expand...

You can... but you must explicitly include the parameters in the
query's Parameters collection. Open the query in design view, and
select View... Parameters or rightclick the grey background and choose
Parameters. Put the [from] and [to] in the left column of the popup
box, and specify that they are of Date type.


.
Click to expand...
Click to expand...
 
i right clicked on parameters on the left side where it
says parameter what goes in there just the bracket
[From] and in the date type box put Date/time and then
below do i put [To] and next to that Date/time do i
need to use between and And ?
Click to expand...

What you need on the two Parameters lines is the two parameters in
square brackets; if on the criteria line you have

BETWEEN [From] AND [To]

then you should have

[From] Date/Time
[To] Date/Time

on the two lines in the Parameters dialog.
 
I Got it to work thank you all so much i cannot
begin to thank you i owe you all
-----Original Message-----
You DEFINE the parameters as you have.

THEN you use the defined parameters in your criteria as you have in the past

Field: SomeDateField
WHERE: Between [From] and [To]
i right clicked on parameters on the left side where it
says parameter what goes in there just the bracket
[From] and in the date type box put Date/time and then
below do i put [To] and next to that Date/time do i
need to use between and And ?
-----Original Message-----
On Wed, 21 Apr 2004 06:05:54 -0700, "Don"

have a crosstab query that runs off of a select query.
im trying to make the crosstab a parameter prompt by
doing between [from] and [to] but it gives me an error
message that the microsoft engine database does not
recognize can i not do a prompt with access 2002
Click to expand...
like
in
my old version?

You can... but you must explicitly include the
Click to expand...
parameters
in the
query's Parameters collection. Open the query in design view, and
select View... Parameters or rightclick the grey background and choose
Parameters. Put the [from] and [to] in the left column
Click to expand...
of
the popup
box, and specify that they are of Date type.


.
Click to expand...
Click to expand...
.
Click to expand...
 
Back
Top