Recent content by Beemermonkey

Thanks Heh, I found the trail just before you posted this response! It took me awhile because I kept trying to set the First() thing on the ItemNo since in my mind that's what I wanted. Although I used First(X), and i ran into another problem because one of the fields in my real data is an...

I have a table like this Stuff. ItemNo Name ImageName 123 Foo 00123.jog 123 Foo 00FOO.jpg 123 FOO FOO123.jpg 456 bar 00456.jog 456 BAR 00BAR.jpg 456 Bar BAR456.jpg ... I want to do a query...

Uhhhh.. I'm not sure what any of that meant... I'm a total novice in Access in case it's not blindly apparent. I'll do some poing around on "crosstab" in google.

For some reason, Access2003 will not let me print anything, nor create a report (reports spit up a really unhelpful message about "can't create report")) If I change the printer to say my PDF writer or whatever, it prints just fine, but when I change my printer in the printer control panel back...

Let's say I have two tables: Product. Item Description A It's Red B It's Blue C It's Green D You'll love it Category. Item Category_name A Cat1 A Cat2 A Cat3 B Cat1 B Cat4 C Cat1 C Cat6 I want to create a...

I just had a chance to try it on the live data and it seemed to work. I see what you're talking about with the leading zeros a they sort the same numerically as alphabetically. Thanks again for your help!

But ow do I do a numeric comparison between items that are stored as text? They have to be stored as text, so I'd magine there's some way of converting them to numbers for the sake of this one query, right?

More help needed... Real world intervened! OK, I need to come back to this as (as usual after jumping into more detail things got more ugly) It's the same idea, I have a bunch of products that are in possibly multiple catalogs. I have one table that details how the catalog sections are laid...

I didn't notice it, however, it was a q'n'd gen of data in Excel that I just imported into Access. Thanks for the help. I'll give it a try ASAP and let you know how it works on the real data.

That would be awesome That's like saying that flying is not that tricky with the right gravity! :) Here's a quick sample dataset... The query would need to return Values_to_classify.Item & Class_range.Class based on where the Values_to_classify.Value falls withy regard to...

First off, please be gentle with me, I am a total noob on Access/SQL/etc.... Here's what I'm trying to do. let's say I have one table with data like this Class range Class ValLow ValHigh ----- ---- ---- Class1 0 50 Class2 51 65 Class3...