Search results for query: *

I have different product types in multiple cities with a report listing the product type in each city with the detail records of each type grouped by city. I am trying to get a subtotal of all of the different product types skipping the detail records. I have tried having a header/footer for the...

thread703-1386902 I want to respond to dhookom, many thanks to this thread above. Been trying to figure out how to do a count distinct in the report to no avail. The way dhookom explained how to do it works perfectly! thanks again

Steve, I set define off and the package compiled clean. I think that was it. The package is being used were variables are entered on the screen and passed to the package. It looks like after I set the define off and got a compile, I was able to run the program ok. Thanks a million for the come...

I am trying to compile a package that has globals in the packages as &case id, &begin date. When I compile the package via SQL it stops me to enter the global. The package is not for one specific case id as above but for any case id I enter when I use the package. When I ran it, I just hit enter...

Thanks Dian! I converted it to a string and that worked fine! Thanks for the info! Ron

Hopefully this is easy and it's my knowledge that is hard!! I am comparing two double numbers: if ( h_chrg_amt) == (h_amt_to_pay) But I am pretty sure the decimal point is the killer.. Some of the numbers are equal up to the 2 decimal position but not after that so it says they are not equal...

Just in case anyone else has this problem. I could not figure out how to print the Bottom portion of the bill on the last page of the bill because how do you know when is the last page until the bill comes up. So I put the 'Please Remit' portion on the first page of the bill. This will work...

Remou, I finally tried what you said and it works partly and I have tried other things and could not figure it out. This is what is happening. I did insert the code above. On the bills with ending on one page the 'Please remit... shows up at the bottom. great! On the bills that have multiple...

thanks Remou for the information. I will give this a try. Thanks also for the quick response! Ron

I have a report that is printing bills and at the end of end bill I have a section that is the 'cut and return bottom portion with your payment' with the info from the bill. I current have it in a group footer rather than a page footer so as not to print on every page. If all bills were one page...

This is killing me and do not know where it is coming from. I have a main report with 2 subreports. Each subreport only has a detail section. Main report has a bottom page section with the system date. Main report has a main query with a location field. Each of the subreports has the same field...

I am printing a report grouped on judges and data for each judge. One judge data per page. I do not have a report heading, only page headings and footers. In the page footer I have a page break. Problem is the first judge's name shows up on page one AND two, Rather than the second judge on the...

Duane, Tried what you suggested and it works fine. If no recs are found it puts out the report with the total id = 0 rather than #ERROR. Both what you and Remou work fine. Two different approaches for same result.. Thanks to both of ya'll for the help.... Ron

I tried what you mentioned and get a Run Time Error 2585 - This action cannot be carried out while processing a form or report event'. I put this in the On No Data Event. Ron

Sorry, after I sent the msg and started going through google, found what you meant. I set that up and it is like you mentioned, when I run the report I get a message that I put in of 'No Records in Report'. You would not know of a way to where I can generate the report and in the field that I...

When I click on the "Event" table on the properties of the field, it is blank. How can I setup an On No Data event?

I have an Acess query that works ok. Problem is at the end of the report I want a total count of all records. Each record has one ID, so in the total field 'Control Source' properties I have =sum(id) which works fine if I have any records and gives me a total count in the report. If there are no...

Jaggie, The audit connect only writes records when a person logs in and out? Probably would have to clean up every week or so depending on the amount of traffic. Have to look into this approach also. Thanks! Ron

Thanks Mufasa! I appreciate you sharing your scripts. From looking at them, it takes in all the fields that I am looking for. I am going to see about modifying it so that you can enter a start and ending date and get all the detail records for that period. This will be a BIG help. Thanks...

Thanks for the info. I will check to see if we have auditing on and see what it takes to check it. Mufasa, if you don't mine, could you post the code for the trigger? I think it would also be helpful. Thanks for help! And for the forum!! Saves alot of searching! Ron