Recent content by plasma

great, thanks

that's what i was thinking, but I just can't remember how to do that..

I'm trying to create a report that will only pull data from a specific category. For example, I have a Table, called "Category" and inside it has 3 items listed: "cpu", "mobo" and "ram". I also have a Table that contains more data specific to my categories, and also references those...

thank you, that does work perfectly. I guess I was trying to work this out in a search funtion, which I would still like to do. Some of the other data I have may require searching in the middle of the test string instead of the end. I was hoping to get that figured out so it could cover...

thx for the replys all i can figure out is: =IF(ISNUMBER(SEARCH("a",E3,3)),"A","") For some reason when i try and next searches ie. =IF(SEARCH("A",E3,"A"),(SEARCH("B",E3,2))) I'm getting errors. how would I make that so it will search for the A or B and then return which it finds?

not sure if I can explain this correctly, but I'll give it a shot.. I have data in a cell with with either end in a "A", "B", "C", "D" or "E" for example A 1 GA08150A (or it could be GA08150B, GA08150C, GA08150D or GA08150E) the GA will always stay the same, the 08150...

I have one sheet with the following info: A B C 1 Name Company Contact Number 2 3 John Company A 555-555-1234 4 Eric Company B 555-555-5555 I...

Hello, I'm trying to sort a column in a Report and I'm having problems. The column I want to sort is a formula, and therefor would not be listed under the Field/Expression column when sorting. I've tried adding the formula as the expression, but it would not work. Is there a way to get this...

yes, it's a date/time field, although the time does not matter.

I am unable to upload anything from work, but maybe I can explain and someone can get me started.. Tables: Products Just 4 columns, with an example Product ID Product Name Lot Number Expiration Date 1 Standard1 976-3na 05/25/08 2...

If tried this, but for some reason it's coming up with no results. I'll keeps hacking away and see if something works.. thx

would I do that in the Table, Query or ? and could you please give me a little more explanation on how to set this up? from what I can tell, I can specify the dateadd to look for a specific month, but how would I set it up so it so it compares the expiration date to the current date thx

Hello all! need some here here. I'm making a Item db where the items have expiration dates, and what I'd like to have is a report that will show items that have expired and items that will expire in 1 month. For some reason I'm stuck getting started, could anyone point me in the right...

thx guys. got it worked out..

Hello all. I have a Report that hides duplicates of a Item name, but does not hide a date associated with that Item. ie. Product Name Date used Product X 8/11/07 8/13/07 Product Y 8/10/07...