Recent content by JimWho

I've been upgraded to Office 2003. I also made sure I have the usual references in VBA. My report puts the year in the title (in header) using the formula shown in the subject line of this message. For some reason it is now not working. When I open the report it asks for Format? and then...

I have a mailmerge word document that when launched opens up and retrieves data from an MS Access query. The query has two parameters that must be completed, customer name and date. I then manually merge to a new document. On the new document I have a Send Mail button which when launched asks...

Mr. VBSlammer Thanks so much for responding. I inserted your code and it resolved one problem that being where I had an empty value in volumes so that now 2 from nothing results in nothing. I think that is correct, bosses may have another opinion? It did not however resolve my problem of...

Why doesn't CDec work in my report? I have 2 subreports with numbers in them. I need to have the frequency between those 2 numbers. For example: No. of Claims / No. of Vehicles Shipped. 5/1138 = 0.43% With my code all of the fields provide the correct output with the exception of the numbers...

Why doesn't CDec work in my report? I have 2 subreports with numbers in them. I need to have the frequency between those 2 numbers. For example: No. of Claims / No. of Vehicles Shipped. 5/1138 = 0.43% With my code all of the fields provide the correct output with the exception of the numbers...

Duane: Many, many, many thanks. I created two subreports. One for the exceptions and one for the claims. I then created a grouping in the main report called Exceptions and put both subreports in this grouping. Worked like a charm. I then created a third subreport. It is a copy of the...

Thank you BUT, hide duplicates does not do the trick and the subreport is grouped on ReportNbr. Also the subreport Header and Footer are empty and turned off and there is no ClaimNbr. Would welcome other suggestions.

My main report lists damage exceptions in the following format: RF Door Dent LF Door Dent F Bumper Dent The data comes from Report Number 5 I have a claim for damages which is linked to this report. The claim (subreport) contains the following: F Bumper Dent Towing The Main Report is linked...

Thank you one and all. You have been most helpful. Nullsview is without an area of wonderment, however for my purposes filling n.a. does without a doubt provide value. A fellow commuter saw my perplexed look while working on the train and I explained my problem and he suggested the following...

I have a table where some fields do not have any data. I guess they are considered to be null? Anyway, I would like to update these empty fields in this table with n.a. but I haven't a clue how to do this. Can anyone help in plain english. I am as green as they come. Jim

Thanks for your response. I think I wasn't thorough enough with my question. The Name, Total, 04/01, 04/02, 04/04 are the column labels that come from the crosstab query. The Name and Total would not change from month to month but the 04/01, etc would change each month i.e 04/01 would change...

I have 4 crosstab queries that count different types of registrations. The results are: Name Total 04/01 04/02 04/04 etc. I would like to put all 4 query results into 1 report. I guess there would be 1 master report and 3 subreports which I haven't tackled and not quite sure how to go...

I have an Oracle SQL that is sent from Access through an SQL Pass Thru. In this SQL my WHERE statement has a date field which I must change to a certain date. Is there any way that I can set this up as a parameter so that when I run the query it asks for the date before sending the SQL through...

I am using a function which counts business days and takes holidays into consideration. I am using Access 2000 in Canada if that means anything re dates. When I get the error message I select debug and it takes me to this line "dteTemp = dteTemp +1" when I point my mouse pointer...

Sorry I can't help you Brett. Access, me and SQL as I know it don't get along. I use SQL Navigator although I would like to get a handle on Access SQL. Jim