Search results

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

just thought of another question. would it be possible to have a pop up box come up stating something is low in quantity or out of stock? I would want this to happen when the database is opened.

I have an inventory database, and would like to know if there was any way to have a auto email notification when a specific item in a table is out of stock, or is low in quantity? I know who to do the auto notification when a form is created or modified, but I can't seem to figure out how to...

never mind, i figured it out. here's what I did: =IIf([ReorderLevel]-[Units in Stock]>=0,[ReorderLevel]-[Units in Stock],0)

Hello all, i have a calculation in a report that sometimes results in a negative number. is there anyway to make that negative number = 0 or equal to a specific text?

thx, i was just getting ready to post that I was able to get that figured out (fumbling through the settings). i still have a few more issues. once i try and work through them, I'll post here for more help if needed. thx again.