|
Subject:
|
HELP! FIXING MY QUERY
|
|
Posted By:
|
dstein4d
|
Post Date:
|
1/20/2006 5:14:01 PM
|
First of all I have only two weeks of experience running MS Access so this is all new to me.
I'm using a form to enter in search criteria. I'm using an option group to select the type of search. Option 1 has 3 text boxes to enter in criteria for my query. I've added 2 more text boxes which each has its own option group to select what criteria you want in those txtboxes. before I added the 2 txtboxes the query ran fine. With the new txtboxes I cant get the original txtboxes to filter properly. the new txtboxes seem to be filtering properly. In my query under each 5 fields my criteria is simply:
[Forms]![Fsearch]![txtQtr2]or [Forms]![Fsearch]![txtQtr2]is null
of course each criteria refers to the appropriate txtbox.
Is my criteria wrong? Do I have too many? Do I need a different expression? I would like to use the new txtboxes no matter what option group I select.
any help will be greatly appreciated!!
|
|
Reply By:
|
anukagni
|
Reply Date:
|
1/21/2006 1:46:04 AM
|
I think u want to select the data for searching through an front end by using an combo Box or by text box (or) directlly by running the query . Right on that ? ..
Then u have to use the table for creating the query and use "Like[Forms]![Fsearch]" in criteria
through Expression builder
If ur an Front end user then following commands.,ill be
Enter to specified front end (i.e.Formview -FSearch)- Then go to design view ,Properties , Data tab ,give data entry "yes".
This may be help full for u , But i am able to understand ur concept marginally.
Anyway try the above said concept..
bye,
P.A.P.Raguv
|
|
Reply By:
|
AccessMaster
|
Reply Date:
|
1/21/2006 2:24:57 AM
|
Try this:
[Forms]![Fsearch]![txtQtr2] or Is Null
Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com
|
