Search results

i can't get any benefit from this

hi all i am running a ms access project on my computer, but now i have changed my computer monitor, now i have purchased a LCD. But my ms access project is not running properly on this LCD resolution. is it possible that my ms access project will be adjusted automatically on every computer...

Actually i am not using the Transaction Date From "Main Query" I am Using Transaction Date From "Issue Query" And i am also using this formula in that Query named "issue Query"

i am using DAvg formula in a report field [avgrate] as......... =DAvg("[Rate]","Main Query","[TranDate]<=[Reports]![Issue Plot/w]![Trandate] AND [Rate]>0 and [Itemdes] = '" & [Itemdes] & "'") but when i want to sum this field in report i dont get any result now i want to use this formula in...

is there any other solution?

Hello All I am facing problem to sum up in report group footer of a field for example i have some fields like......... Qty(A)---Value(A)----Rate(A)---Qty(B)----Value(B) 5----------25---------5---------20---------100 10---------50---------5---------10----------50...

Hello All I am facing some problem in subtotal of a field called rate in which i am using this formulla =DAvg("[Rate]","Main Query","[TranDate]<=[Reports]![Issue Plot/w]![Trandate] AND [Rate]>0 and [Itemdes] = '" & [Itemdes] & "'") but when i use to sum this field the result is "0" Plz...

Hello all How to hide a whole field in ms access report based on a null/zero field? :)

Hello All I am facing some problem when i using the DAvg Formulla I have a Query Named Main Query. It contained data as... Purchase Qty--Rate--Purchase Value---Issue Qty---Issue Value -----50--------10------500----------------0----------0------...

Ok thanks to all of you.

yes i am using a query to populating my report but i don't want to use criteria from query i want to use criteria only in report

i am not using the query as source of report . i want to put criteria in only report not in query

is it possible that can we use the criteria parameter in report instead of a query?

any one help me plz

is it possible that we can use the criteria parameter in report instead of a query?

yes source is a form and that form is opened

yes these prompts appears only when the database window is in hidden mode

Is there any solution in vb for this problem?

Yes there are prompts appearing for entering range of dates

I use to hide database window from tools> startup option.