Access issue (quite urgent) View previous topic :: View next topic  


NFOHump.com Forum Index - Applications
Page 1 of 1
maxiepaxie




Posts: 1732
Location: Belgium
PostPosted: Tue, 24th Jul 2007 17:22    Post subject: Access issue (quite urgent)
I have to make an access database for my father, but there's one thing I couldn't find a solution for : In one of the columns (vertical) I have to fill in the ingrediënts of certain stuff. Now my dad wants to be able to make a query and find one word, for example "apple". In this column there are multiple words: "1 apple, 2 mushrooms" as an example. Now when I make a query for another column with only one word, and filling in the criteria, I can find the result. When I run it for the ingrediënts column, it can't find anything. Is there a way to "fix" this? should I make different columns for every ingrediënt or perhaps sub-columns (if that's possible).
Thanks for your help, my dad wants this finished, he's starting to annoy me.
Back to top
swingman




Posts: 3602
PostPosted: Tue, 24th Jul 2007 18:37    Post subject:
1.Try putting quotation marks around the word you are querying on in the criteria field. ie type "apple"
2. Use Like in the query. ie put (Like "apple") in the criteria field. Withouth the (). Razz

Been a long time since I used access so I may be way off.

In the long run I think you would be better off coming up with a more logical and ultimately more searchable database.
Back to top
maxiepaxie




Posts: 1732
Location: Belgium
PostPosted: Tue, 24th Jul 2007 19:55    Post subject:
I already tried that... Any other suggestions? Or should I just link seperate ingredients to the different records :/
Back to top
swingman




Posts: 3602
PostPosted: Tue, 24th Jul 2007 22:54    Post subject:
Try this in the criteria - Like "*apple*"
Back to top
maxiepaxie




Posts: 1732
Location: Belgium
PostPosted: Wed, 25th Jul 2007 00:30    Post subject:
Dude! I owe you big time. Yeah, it seems like that works, I wonder why I couldn't find it in this access 2003 book I've been using. Smile
Back to top
swingman




Posts: 3602
PostPosted: Wed, 25th Jul 2007 08:23    Post subject:
You're welcome. And most books spend the first 60 or so pages on really trivial stuff so by that time people tend to lose interest.

Btw if you're doing this to learn access then it's a good idea to just jump in and dig around and specific subjects you can always google up. But if you have no further use of learning access then you're much better off just searching for some program written specifically for cataloging recipes. I mean no sense in re-inventing the wheel.

Try this
Back to top
Page 1 of 1 All times are GMT + 1 Hour
NFOHump.com Forum Index - Applications
Signature/Avatar nuking: none (can be changed in your profile)  


Display posts from previous:   

Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB 2.0.8 © 2001, 2002 phpBB Group