Recent content by decie

That is just too easy!!! Thank you! In thinking ahead, how would I accomplish this if I needed to hide duplicate from one field, only if 2 would duplicate? For example, Acct# Amt 1123 25.00 1123 25.00 1124 25.00 In the example, I would only want to hide the 2nd 25.00 but show...

:confused: I have a report where only the invoice number and invoice amount fields duplicate with each record related to that invoice. How do I prevent the invoice number and amount from repeating on each line except for the first instance? Thanks so much for all your help.

Did you try changing your Bound Column to the first visible column? For example, first column(not visible) 1, second column (visible) 2; Column Count: 2 Column Width: "0"; "1" Bound Column: 2 Here's an example from one of my applications. The user gets inquiries from various newspapers and...

I'm currently using a treeview control form, where based on a selection in level 2, (on the left side of the form) a particular subform becomes visible (on the right side). I have several subforms sized and layered on the right. The need for additional subforms has increased dramatically. Is...

I want to try and handle it in the code example in my first post in this thread. I just have to think it through. I guess another If statement to identify if the next weight in the same species is either equal or greater/less than the current one. Then if so, intplace=intplace, or something...

I used your suggestion on returning the max weight. My query was originally a select query. The statement in the criteria selected the top 5 by species perfectly. Once I changed it to a totals query and set the Totals field for Weight to Max, this solved my problem. (See my example.) Thanks...

To get the top 5, I currently am using a select query with the following statement in my criteria. Should I be using a totals query instead? I'll give it a try and compare the results. Thank you. Any ideas/suggestions are greatly appreciated. In (Select Top 5 [Weight] from [002--RecCatches]...

Yes. I discovered the error late last night. Thank you so much for responding. It is such a relief to know that help was available had I not realized my mistake. I do have another issue to tackle if you happen to read this again. Here is a more involved explanation. This is a fishing...

I have already created a table of top five winners by categories from a query. I want to go back and update the table with their places in each category (1,2,3,4,5, 1,2,3,4,5, etc.). My code numbers, but doesn't restart with the change in category. Here's what I have so far. The first query...