Qeury dates

[cgmckenzie]

I have a table with fields pickup date, delivery date, cost, company and so forth. I made a form called weekly summary. I typed a control that says "Input start date and finish date" and an unbound control. I can make a query to find the information i need by putting in the criteria for the pick up date "between 4/14/03 and 4/18/03". what i need is to be able to input the beginning date and end date information from a form. Later I will link the information the query pulls up to a report. thank you for your help Chris

 

[cgmckenzie]

I think i fixed it myself i put a command button on the form to open the query then i set parametes for the pick up date so it prompts me for the start date and finish date. this works but can i get the information to dispay in the form instead of the query box. Thanks for your time Chris

 

[FoFa]

You can use fields on your form to put in the dates and reference your form fields in your query.

 

[cgmckenzie]

Now it prompt me for the start date and finish date twice is there any way i can fix this thanks Chris

 

[FoFa]

Each time the query runs, it prompts you, so it must be running twice. I would base the parameter on fields in your form.