Recent content by Mattster

I would use the onformat for the total section, and change the visibility setting on whatever. You should be able to use a count, to determine the number of records, or just setup a counting field in the query. The onformat would look something like if Count = 1 then TotalBooks.visible =...

I am assuming that you are using two tables one that contains the different sections Region, Department and Salesperson ... And a second table that contains the dates. if you link these together with no joins I believe that you will have the dataset that you are looking for. Then just sort...

What did you want the information to look like Account Jan Feb March April May June Tom $10 $50 $60 $20 $30 $10 Julie ... if this is the case I would make up fields inside your system I am unsure how you are storing the data so I...

I do an on format function that basically renders an image. I have a sub form that contains only an Image place holder that I properly size. In the main report, I place that subreport and also provide a field with the Image file path. In VB I have written this simple code. ' Verifies...

that function seems a bit odd. I am confused a little about and [Itemdes] = '" & [Itemdes] & "' Unsure what this is doing. if you remove this section do you get the result you are going for. this statement to me, and I am not the best, is saying get ?? apend it to [Itemdes] apend all this...

I am trying to a data transfer to SQL and therefore I need to clean all of the text feilds such that the returns are modified to an odd string so that I can post process it on the other end, otherwise the transfer, fails in sooo many ways, lol. (I have currently tried ^| which is the process in...

to access this, when you are in the report go View > Sorting and Grouping

Based on the information you provided, use the sorting feature where you would sort first on ID and secondly on Status for the Status section create a footer and display the information you would like for that record in that section. Pretty sure this will work, but you will need both sorting...

Awesome glad to hear it. By the way I would have never thought of that solution.

Yes that is very possible Kevin, I would do this such that your report references a form, with two feilds date1 (early date), and date2 (late date). Inside your query for this report reference these two dates >[date1] and <[date2] Hope this works

I am unsure if I understand you correctly. Currently you are producing three different reports and you are trying to merge them into one or do you have three different datasets for the same report? For option 1 three different reports. 1. Create a new blank report 2. Drag and drop the...

My guess is based on what you are saying the data types are all the same. Therefore you have three dataset that are the same report. I have done this by using View > Sorting and Grouping. Place the header in the category that seperates each reports data, and in the footer ensure a page break...

I think you might have put the value in that groups header. If so you only have one header per section of that perticular data. This must be inserted in the Data to have a proper number of records show x y z 1 A 123 1 B 5 2 A 3 If for x I had a group...

Thanks, it appears that establishing the microsoft settings to inches worked. I will check out the drivers as well to ensure they match.

I apologise, I missed that, only got to the end of the first page. On the other hand my issue still exists that the margins are modified, when I publish to one machine in perticular. The only thing I can come up with is that he is using Metric, versus the rest of us backwards people who are...