Search results

Thanks I await your response

Anyone have anyidea on this one,,,, :(

Do you happen to know of a sample DB of wht you are refering to. Thanks for the help

:confused: I have to build a query to do the following my table consists of 7 fields cg price gross open IM state sdate I want to build a query that will prompt the user for 3 of those fields: price , gross , IM BUT:confused: when prompted I want the user to have the capability of changing...

Ok this is now what my SQL statement is, How ever if you look i have an expression that calculates [weight]*[percent full] then returns the total weight.... But the way the statement is now it returns 0.00 PARAMETERS [Enter Date] DateTime; SELECT RM_DATA.mat_type, RM_DATA.vendor, RM_DATA.po...

If I can get the attachment of my error to show up this is what it say" The expression is typed incorrectly, or its to complex to be evaluated. Try simplifying the expression by assigning parts of the expression to variables" No I removed just one of the criteria's and it 1/2 way wrks.

well houston there is a prob, This did not work I need to attach my screenshots how is that done here, I uploaded the images but i can not find them

Great work, I will try thanks for all I knew there was a way and I knew what I wanted Thanks Again

no because i can have it prompt like this between[Enter Date]and[Confirm Date]

No not really, Yes I have a table with the following rec_date rel_date weight po# I want to prompt the user for A date (not specificly the rec or rel date) just a date. then based on that date I wan the qry to see if the rec_date <= the date they entered AND the rel_date is > the date they...

But I only want it to return the data as follows if rec_date <= Prompted [Enter Start Date] and rel_date is > Prompted [Enter Ending Date] then weight else "disregard record" If I leave the rest out it just returns all records in that date range I need it based on the qry

Kraj, Thats makes sense for what I am looking for except my form is the same form as what the user enters data in, What I need is for the user to open this form, the control goes to the first field, then from here the user can click in a field that they want to search on. Example I have a field...

Yes I can get that but what about the IF Ten Statement, where do I place that at..

Is this placed in the QRY in the field section or criteria section ?

I have a need to prompt a user for a date, When they enter that date the qry should do as follows. if rec_date <= (DATE PROMPTED FOR) and rel_date is > (DATE PROMPTED FOR) , then return Qty and a few other fields.... No the DATE PROMPTED FOR is not a field in the table. Do I need it to be ...

Never mind figured out what I was doing wrong, Thanks for all the help

whoops !!!! Field Names Com-Balance Com-Amt Pd Com-Due

Do I attache this event to my Form field ? This is my actual field names Comm-Balance Comm-Amt Pd Comm-Due

I have 2 fields in a table 1. called CommAmtDue and the other called CommAmtPd, When the user inputs a value in the CommAmtPd I want the CommAmtDue - CommAmtPd = CommAmtBal I want this value to be stored in another field in the same table called CommAmtBal I can do the formula in a query but...

BTW DO I have to delete all the reports, forms, etc if I only make a change to 1 form or reprt etc.