Search results

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...

I have not been able to rectify this issue with my office either, I believe it has to do with the metric / imperial setting on the Microsoft settings. What I believe is happening is that your margins are being set to whatever is setup on their machine. If you find any answers please keep me...

To either remove the $ symbol or other common text simply highlight that column and use Edit > Replace where you will replace "$" with "", make sure you search such that it will find any part of the cell and not the whole cell. Also if you are converting this to all number values, it would be...

Depending on how you would like to do this, it is potential to put a click box above each item, therefore they select this checkbox for which fields they want. I am unclear how you would like the report to display, if it is in column method this will not work, but it should work, if you are...

A fellow scouter. I would simply create a second table that defines the badge entitlements where one record would contain BadgeName, NightsAway Then simply in your query, have a <= result, so you have a result of 7 coming out already that is the data that you would put in against the nights...

The simplest way to perform this would be to avoid sub reports. I would construct a quesry that will return the employeeID and the secondary table Warnings joined as you would normally. And have it sorted based on the employee ID where you have a group header for the employee and in the detail...