Apr 13 2006, 09:21 AM
I am using a table to sort different item numbers according to what type of item they are. In my report I need to have a header to separate the different types of items in groups. My problem is that 3 of the numbers are not consistent. For example: RND_Pt13_Stock. This item needs to be Round when it is sorted in the report. The RND is always there but the last part of the item is constently changing. I'm not sure how to refer to this in my table. I tried RND* but that doesn't seem to work.
Any help would be greatly appreciated.
Apr 13 2006, 11:52 AM
I forgot to mention that this is an imported text file so the data that I'm using isn't entered in with a form.
Apr 13 2006, 12:34 PM
Add the field that RND_Pt13_Stock is in to the Sorting & Grouping dialog box and sort it acending and set it to have a header for this field.
Apr 14 2006, 08:29 AM
I probably didn't explain it quite right. On some of the things it's hard for me to put in to words what I am trying to do.
My problem is probably a table thing where I need to have 2 columns. 1 column is the item number. the other coulumn is the category the item belongs in. The first column is linked to a main table for the orders.
What I need is to have the report sort to the second column (which is not a problem). The problem is that the data in the first cloumn that is brought in as a text file is not consistant. It always starts out with RND- or HRT- or BOX- but the final part of the item number is random numbers. The rest of the data for that column is good. It comes in using the actual item number like 70145.
What I wanted to do is to make the RND, etc. use the Round category. I tried entering it several different ways in the table. RND* , Etc.
Nothing seems to work.
Is there a solution for this or should I be going down a different path?
This is the best I can explain it. Sorry about the confusion.
Apr 16 2006, 09:22 AM
What I wanted to do is to make the RND, etc. use the Round category.
What do you mean by "the Round category"
the final part of the item number is random numbers
What do you want to do with this part
Apr 21 2006, 09:42 AM
Thanks for your help but I found a way around this problem. I found a way to edit the original data to help in the sort. I know I didn't explain the problem correctly. I just read my post and cringed at how confusing I made it sound. I have to work on my writing skills.
Thanks for trying to help!
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here