Recent content by patelnitesha

Hi there, can i use nested function in access form to get a value for list box. Here is the following code i am using. sql = "select invoiceNumber as InvNo, iif(sum(value_os)=0,'**Paid**',iif( (type<2) and...

Hi thanks, I have changed all to Sum .. now it is working fine. Many thanks for your help.

Hi Chris, I have attached both the design and result of reports as well. i have attached the second and third page of report ...the circul shows where the error come. this Top service is onley having wrong value...i tried to get value byr query and found that it calculate one delivery of that...

Hi, I have having a proble with Reports in Access 97. We have a report which gives the total value about all the deliveries by delivery type. everything is fine...but when report generates new page(2nd,3rd....) the top delivery type has got the wrong total. and i have found that on each new...

Hi there i have tried to write whole report but it is still niot working...from my analysis it looks like that it report has more than one pages thetn this problem occure...for one page report it is working fine..please anyone can hellp me...i am stuck here...

ok. will try this one as well. lets see..

it was working fine before 2 days...but here is the code... Private Sub GroupFooter2_Format(Cancel As Integer, FormatCount As Integer) Select Case DateDiff("d", Report!invd, Date) Case 0 To 30 Report!curr = IIf(Report!groupdeb = "", Format(Report!groupcred, "-0.00")...

Hi .. I tried to repair local file..and it was repaired successfully... but the problem is still there... the details part of report is fine but the footer whcih dispalys the total of detaisl is not correct..it looks like it is calculation all the details value twice...i have made sum by my...

hay...what would i report the local file or my database on server...

hi.. i will try this out and if no luck will give a buzz... thanks for quick reply.

Reports has been changed suddnanly ...gives the wrong Total. Hi There, I have a big Problem. We have a system in access 97. Everything was working nice 2 days ago. Now suddnely the report are wrong mean at the end()footer sum is wrong etc. I tried to use my old back up file but it is happing...

it is like here DoCmd.OpenReport "tempServiceReport", A_PREVIEW, , G_REP_var1 DoCmd.OutputTo OutputReport, "tempservicereport"acFormatXLS, "ServiceReport.xls",_ True where G_REP_var1 = "InvoiceNumber >= " & invfrom & " AND InvoiceNumber <= " & invto & "" and the report has Record Source like...

yes it is based on prebuild query.

I tried it. it also saves in Excel but no data..only with some text box names. no data at all. Could you please tel me how i can get all data in to this Excel file. lost again.. Nitesha

thank you. I will try that. Thansk for quick reply. Nitesha