Parameter query and sorting

[Guest]

Hi,

I have a parameter query that prompts the user for a begin date and an end
date.Problem is when i apply sorting to one field(not the date field), the
query now prompts twice for the begin date and end date.How can i prevent
from having a double prompt?
Thanks

 

[Van T. Dinh]

Sorting shouldn't affect how JET requests the parameter values.

Post relevant Table details and the SQL String of your Query.

 

[Guest]

Thanks,

This is the sql view when i add the acending option in query:
WHERE (((InvoiceDetails1.DteComplete) Between [Start date:] And [End date:])
AND ((InvoiceDetails1.AdjEmp)=[Enter Employee Number]))
ORDER BY InvoiceDetails1.InvNum;

I am trying to group the same invoices numbers together......

 

[Van T. Dinh]

Looks to me that you have 3 Parameters: [Start date:], [End date:] and
[Enter Employee Number].

If InvoiceDetails1 is a Query, check whether there are Parameters in it.

You are simply running the Query through the Access Query interface?

 

[Guest]

Thanks,

This is a simple select query with 2 parameters....start date, end date,in
the date field, i parameter for the enter employee number...in the employee
field.......all i did was place the sort to acending on the invoice num
field and then i started receiving double prompts.....The record selects are
correct but the double prompts are a bit of a pain....Any ideas?

Looks to me that you have 3 Parameters: [Start date:], [End date:] and
[Enter Employee Number].

If InvoiceDetails1 is a Query, check whether there are Parameters in it.

You are simply running the Query through the Access Query interface?

--
HTH
Van T. Dinh
MVP (Access)

Thanks,

This is the sql view when i add the acending option in query:
WHERE (((InvoiceDetails1.DteComplete) Between [Start date:] And [End date:])
AND ((InvoiceDetails1.AdjEmp)=[Enter Employee Number]))
ORDER BY InvoiceDetails1.InvNum;

I am trying to group the same invoices numbers together......

 

[Van T. Dinh]

I have never seen this. Now run the Query and check the Parameter Dialog
*carefully* for the spelling of the repeated Parameter value requests.

Do the repetitions have the exactly the same spelling?

Post you OS version/SP and Access version/SP also.

 

[Guest]

Thanks for your assistance,

I discovered the error in type.