Search results

I have a field that holds item numbers. They are usually a number, but sometimes contain other characters and/or spaces. e.g. 123456 456789 789123 ABC123 BLAH01 456 XYZ When I query this field using LIKE and a wildcard, I am not seeing any all numeric results: WHERE ItemNumber LIKE '*A*'...

Thanks for directing me to the helpful post LPurvis. RuralGuy, check out the linked thread. Now you know. I think I will use the query method using a 'template' table as described. I have already started writing some do loops, but would rather just use queries.

I am working on a database for inventory of a laboratory. Currently there is a table that defines samples, 'Samples'. This includes a primary key, sample ID, subject demographics, among others, and a numeric field of test tubes belong to a sample 'TubeNumber'. This table must remain intact...

Thanks for the reply, however, this post sat long enough that I could figure it out on my own. Not exactly sure how to close a post, but consider this one closed.

Thanks for the ideas all. For only being intorduced to access a week or two ago, I'm learning a ton.

Ok, that works. I'm still curious if anyone has other approaches to this.

First, a bit about the data: Each record has a unique key (autonumber), and an ItemID (text) that is not necissarily unique nor required, as well as various item information. It is possible that an item with the same ItemID may come through the system to be reprocessed. This would mean either a...

I currently have a basic query that uses a form field. This query is used as the row source for a listbox that has a lot of events associated with it. SELECT * FROM ITEMS WHERE ITEMS.ITEM_ID = Forms![Form 1]!ItemID How can I change this query to work in more than one form, not just Form 1...

Actually if anyone cares, here is a forum thread that I also found really helpful along the lines of my original question. http://www.utteraccess.com/forums/showflat.php?Cat=&Number=783603&page=&view=&sb=5&o=&vc=1

Thanks for the advice Galaxiom, it got me on the right track. Sorry, I only used the # character to abbreviate my field names. They can just as easily be refered to as Snum, Anum, Tnum, Cnum or whatever. I figured out my first problem. I set the criteria for my query to point to the form...

I'm relatively new to Access but very willing to get my hands dirty. Here's a problem I've been trying to figure out for the last few days for a research lab DB. I've got three tables with the following relevant fields: --SAMPLES-- one to many tubes Skey - primary key unique to each sample...