Search results

  1. B

    Return only one record from table with repeating values in fields

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

    Access 2003 will not print, nor allow me to create a report...

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

    Combine multiple records' field value into one field?

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

    Need to perform a "lookup and classify" type query

    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...
Back
Top Bottom