A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

criteria on form



 
 
Thread Tools Display Modes
  #1  
Old May 14th, 2010, 07:37 PM posted to microsoft.public.access.queries
Christina
external usenet poster
 
Posts: 282
Default criteria on form

GOod day
I have two queries pulling data from two tables, with criteria between
start date and end date.

.. I have a third query pulling those results together. I would like to
create a form and to input the criteria for the first two queries. I have
problems with the criteria to put in the query. Grateful for your help.


Cristina
  #2  
Old May 14th, 2010, 07:50 PM posted to microsoft.public.access.queries
Amy E. Baggott
external usenet poster
 
Posts: 79
Default criteria on form

You need to create the form first with unbound text boxes for your start and
end dates (you can actually format them as dates and use an input mask to
make sure the dates are entered as dates). Once you save your form, you can
then put the form text boxes in the criteria for your query. Then go back to
your form and put a button on it to run the queries when you click the
button. I would also put a second button on the form (Cancel) that just
closes the form without doing anything in case the user changes his mind.

--
Amy E. Baggott

"I''m going crazy and I''m taking all of you with me!" -- Linda Grayson


"Christina" wrote:

GOod day
I have two queries pulling data from two tables, with criteria between
start date and end date.

. I have a third query pulling those results together. I would like to
create a form and to input the criteria for the first two queries. I have
problems with the criteria to put in the query. Grateful for your help.


Cristina

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:21 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.