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
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
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
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
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