Qurey- Where Issue

Nov 2, 2007

I have a list box that is updated by a query, here is my query:
__________________________________________________ _______________
SELECT [Work Order Content].[WO ID], [Work Order Content].[Work Order Number], [Work Order Content].[WO Date Ordered], [Work Order Content].[WO Date Needed]
FROM [Work Order Content]
WHERE ([Work Order Content].[Work Order Number]=Forms![open Doc]![WO Number]) Or ([Work Order Content].[WO date ordered]=Forms![open Doc]![WO date ordered])
ORDER BY [Work Order Content].[WO ID];
__________________________________________________ _______________

In the form I have textboxes to set the criteria, what I want is for this to be subtractive, when I open the form all Work Orders are shown and as I change criteria it weeds out Work orders that don't fit the criteria. What must I change to fulfill this requirement. I personally was thinking there must be something better than 'OR' to use, but I really have no idea.

View Replies


ADVERTISEMENT

Search Qurey

Oct 14, 2005

i have created some search querys for my form and the results are shown in a table but i want them to show them in the form which they are refering to?

Any ideas how to do this

View 2 Replies View Related

Can This Qurey Be Modified ?

Aug 19, 2006

(this is a pop up display)

I have this code in a Query...
[Type in your product, such as mtt20]

Once you type in the product it will go
and find it and display it.

My question is :
Is there a way to modify this so it will
allow me to enter more than one product
and then go and get the results.
Preferrably the easiest way possible as I
am a new user of access and no program
training...

thank you...

View 2 Replies View Related

If Condetion In The Qurey

Sep 22, 2007

Dear all,

I wount to wirte IF condetion in the access , can any boday help me in this

If the sales more then 10% = 25
if the sales more then 15% = 30
if the sales more then 20% = 35
if the sales more then 25 = 40

View 2 Replies View Related

Queries :: Qurey To Link With Target Date

Dec 24, 2014

I have to make a query using the following case, I have two tables, in the first table i have the materials and its received date and in my second table i have the month the target date for every month to receive the material. Now linking this two tables, i want to see the from the first table on every month hom many materails i received after the target date how to do this.

Table 1
Field1 Date
Field2 Month
Field3 Material
Field4 received_date

Table 2
Field1 Month
Field2 Target_date

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved