Recent content by gimenes26

i`ve tried but still not working.. i have the same problem i want the autonumber to start at 3000... any chance that u can explain it step by step?

i`ve got a database for work but is locked with password, is any way that i can unlock? i have to change some thing on the report.

I`VE GOT A REPORT THAT I CAN SEND USING Snapshot Format, BUT NOW I WANT TO SEND A FORM.. IS IT POSSIBLE? BUT I DO NOT WANT AS A HTML ..

yes i mean Master/Child.. No.. week sold is in my child report and weekpaying is in my main report.. Basicaly i want that field weekpaying lookin on : weekpaying and weeksold what i want is a look up.. one field looking in 2 fields... i think

sorry.. That main report has basically is only to select the week(that means the week that we sell jobs) year`s week. Main report(1) has : weekpaying,repsname,branch that report comes from a query.. when i type the week number brings all the jobs sold of the week selected.. and i have another...

yes.. i am really using subreports... Each report comes from a query.. so i have 5 queries.. The main one plus 4 more.. I have no idea why is picking the records for weekpaying;weekpaying and is not picking records that i`ve linked weekpaying;weeksold..

I!VE GOT A REPORT WITH 4 SUBFORMS SELECTED BUT WEEKPAYING 1.SUBREPORT = WEEKPAYING;WEEKPAYING 2.SUBREPORT = WEEKPAYING;WEEKSOLD 3.SUBREPORT = WEEKPAYING;WEEKPAYING 4.SUBREPORT = WEEKPAYING;WEEKDEBITED BUT IN SUBREPORT 2 IS NOT PICKIN UP THE RECORDS... COULD ANYBODY HELP ME PLEASE???

i have done a formula in the query.. weekpaying : weeksold+1 example: if we are on week 2 week paying is 3 (we pay the jobs that we sell on the next week) but when i select that week 3 for example on my main report that subreport does not come up with the records.. i work on main report to...

THANK U VERY MUCH!!! U ARE THE MAN!!!!!!!!! I`M VERY HAPPY WITH THIS WEB SITE!!

THAT IS THE FORMULA IN THE MAIN REPORT : =IIf([CASHJOBS].Report.HasData=-1,[CASHJOBS].Report!TEXT127,0) BUT WHEN I HAVE DATA SHOWS UP WITH ERROR... CAN ANYBODY HELP ME PLEASE??

and thanks for the advice, i`ve changed already from: cash jobs to cashjobs :) can u help me with my problem please?

thank u very much for your attention but is not working.. sorry but i meant IIF , is correct in the formula... the point is: i need that subreport total showin numbers, if the subreport has no data i need showing 0, if has data i need that formula : [cash jobs].[report]![totalcomm] cheers

i,ve got 3 subreports on main report each with total price, and i use the hasdata formula but still having problem.. formula for subreports on main report : =[cash jobs].[Report]![totalcomm] on cach jobs report i`ve got : =sum([totalcomm]) and when i have no data shows...

thanks hitechuser!!!!!! is working now , but i have another problem if the subform has no record, the formula shows error , i need showing number 0 for the grand total works!!! if the 1 subreport shows error , the grand total shows error, i need showing 0 for the sum!! would be great if u could...

I`v done a report with 3 subreports on the same page, each one showing separeted totals, but they are selected by week , for exemple if i select week number 27, the report shows me 3 records , if i select week 35 , the report shows me 7 records but sometimes we have weeks with no records , that...