Search results

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

I actually have it mostly written but I'm stuck on using a wildcard character for the numeric digit between the two dashes. How would I pass "-*-" where * is the random digit in between to a variable? I guess I would probably need to remove the dashes as well.

I don't think you understand what I'm trying to do and why yet. I cannot change the field from a string field, and need the locations to remain the way they are. HOWEVER, since they are being sorted with an ascii sort when they are sorted it comes out like this E-1-1-1 E-11-1-1 E-16-1-1...

What I think I want to try is basically an if then statement that looks through the string and if it finds any of the following "-1-", "-2-", "-3-", then it would change it to "-01-", "-02-, "-03-", and keep all of the related fields (it is a primary key field, but I could remove that) intact...

The table is generated through an outside database/inventory program called SBI. On some of the product detail screens the places where information is entered and presented, it is difficult for the people doing data entry to do it quickly because of the method of sorting. My point was that when...

Your field is a string (Text) field and that is simply an ASCII sort. My suggestion is either 1) create the numeric fields you need and populate then from the original field and then sort on the numeric field instead or 2) do the same thing in a query and sort on the created fields. Just my...