Search results

Hi to all; I am not familiar with access function, in Excel its very easy to find the max value at row level, what's the formula in access query to get the max of this example Co1 co2 co3 ….co60 max(co1:co60) 200 150 300 500 ? 212 542 321 222 ? thanks in advance for respond Majed

Hi to all; I have one code of 6 digits; each digit refer to a group; first 2= product group; beverage; live animals,….itc (24 product groups), the 3ed digits= food product, the 4th-6th digit= detail product group; vegetables, fruits,….,the rest of digits refers to product name, carrot...

hi to all; I am new to access, I need help, , my db consist of products and values, : code name value 1001 tomatoes 222 1002 potatoes 425 .. 1999 carrots 111 ( vegetables group: code from 1000-1999) 2001 apple 214 2002 banana 254 .. 2999 orange 354 (fruits group: code...