Recent content by roperj

It worked! That you so much, I have spent a stupid amount of time on that one simple facet of the report. It was complicated because of the differing layers of information that are sorted, and the calculated field that comes from the view.

I've emailed you the db

Alright, so I exported the view the report is based off of into a new table, and based the report off of this view. It s large table that has all of the data, and then just the report. THis is basically how it is currently formatted in my database now. I'm definitely following you on using a...

All of the sub reports I have been making haven't been filtering the data correctly. Most show way too much information, and don't cut it down to just the sale price and discount level for the plant at that size. Should I use the same query as the original report, or a new one? Also, from what...

In which of the groupings should the subreport go into?

Okay, I see how this would definitely work. I need a little bit more help though. How should I set up the sorting and grouping between the main report and the subreport. My first attempt is creating a subreport thats way way to big, I'm also not sure what I should put as far as where to connect...

Alright, I have a somewhat specific problem with formatting data in a report that seems like it should be a simple fix, but most of ways I have looked up to get it the way I need it have proven too difficult. I have a report that I'm using as a brochure that lists prices. There is the base...

I got it working, I think something just went wrong when it tried to debug too many errors that I couldn't cancel out of. I've been revising that statement, the first one ended up cutting off the last digit of a lot of the data entries. Another problem is that this data isn't normalized at...

No, the module is simply called Module1, its in a seperate test db that contains only this module, and the only thing in it is this: " Option Compare Database Public Function ConvertIt(InValue As String) As String '-- Return "E-1-1-1" as "E-01-01-01" Dim InString() As String If...

I'm having some trouble implementing the UDF you posted. I placed it in a module in a test db I made with the table, and then made an update query that says UPDATE [copy of tblICInventory] SET [strWarehouseID] = ConvertIt([strWarehouseID]); It ran the first time but threw an error, I think...

There are several records that do not fit the format. They are just basic descriptions (warehouse, cooler, seed lab, etc) which is why I was going for something that finds single digits in between dashes. The format is basically what anyones enters, but if this was fixed people would only be...

Yes, that is what I'm trying to do, I'm trying to create a function that goes through each row of strWarehouseID and does exactly that to each of the thousands of rows in that field. I have it mostly thought out and somewhat typed up right nwo it searches through and tries to find the string...

Depends on what you mean by alter. For all intents and purposes I only have the ability to manipulate data, not table structure, but I do have full access to the database.

Well, basically I have full access to the database tables, and can change the data however I need, but I am unable to fundamentally alter the table structures themselves. I could split up the strWarehouseID field into multiple number fields, and sort them, but in the end I must recombine them...

I'm only doing that because I am unable to split up the field, I cannot change it from a string field, I can't split it into multiple fields, so I am stuck finding a way to make the ascii sort of a string field sort properly. If I could do it another way I would because it would be MUCH easier...