Search results

Try: IIf(IsNumeric([STK_SALE_UNIT_MEASURE]),[INV_PRICE]/Val([STK_SALE_UNIT_MEASURE])*100),0)

go to the form event paste the code at the form key down event set the key preview of the form to True thats it

great help pbaldy,,, thanks for your great help. i got the concept. now it is matter of logic and , or.. Thanks Alot

Can any one help with this: i havetext box where the user enter the quarter and year , and he ll get the report . there are two conditions, if the report is before the 3rd Quarter 2004 Report1 has to show, if after Q3 2003 then Report2 Has to show. am stuck with the Quarter Declaration.as...

I have to generate a quarterly report. There is a form where the user can type in the start and end dates of the quarter he/she wants the report for. :::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::: why don't u create quarter query based on the source table, then...

Create a queries of the wanted date duration based on the source table ,"use wizard so u can select the date display weekly,mothly....etc" create reports based on that queries and ur problem is solved.

Nice Idea , Neileg...works fine. thanks

delete this admin it's a reply on another thread. tried to delete it but i have no right to do so...

more about thnx for reply WayneRyan guess i didn't explain the problem very well. this is example of what is happening some dates are not exist in the record set cause they r either week ends or holidays.. at the date crieteria i wrote: CDate([forms]![x]![text0]) Or...

thnx for reply WayneRyan guess i didn't explain the problem very well. this is example of what is happening some dates are not exist in the record set cause they r either week ends or holidays.. at the date crieteria i wrote: CDate([forms]![x]![text0]) Or...

i have a query that compare between two working days. in order to compare between the current date and previous working date am using this in the criteria at the previous working date field :" [current date]-1" the problem comes with the Holidays and the week ends. where "[current date]-1" is...

hi , i have a chart report built on a query you will select a date on a form maped to a query,the query will give you the data related to that date and previous 6 days in addition to the day u already selected. Problem. some records are not available in the date field. the Query is ignoring...

Solved hey , i solved it using the Colume Heading setting in the cross tab query properties. i inserted the heading of duration , as "1","3","6","9","12" and it works. thnx

hi, i created a report based on a cross tab query , i have these fields , stock as a row., duration as a colum and deals as data. the duration is divided in to 1, 3, 6 ,9 and 12 months. where there is no deals for 12 months for example, this ERROR msg comes : the Microsoft Data base Engine...

try searching the topic in the report forum , check with access help , use the wizard for creating chart report. or check this site also : www.exceltip.com

solved thanks all for usefull help great examples Pat .

IT'S WORKING. THNX ,,,, :)

same again well....... i don't know why but still the same is happening, i still recieve the msg. INVALID USE OF NULL/ records still empty. this is the DB I created. if you could help i 'll be thankfull

the data are importing , while the date field still empty & I RECIEVED THIS ERROR MSG: INVALID USE OF NULL what i have done is this : at the form i created a text box ,so the user enter the date and the code is like this , Dim xx As String Dim st As String Dim DF as date...

hi, in my data base there is a form with a command button that run a macro for importing excel file to a table of my data base, the table is consisting fields that is uploading when running the macro. and there is" date" field which i desire to make the user enter it Manually ,and let it apply...