Recent content by Majed

DMax Method is for finding maximum value at coulmn level, I need the max at row level thanks

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

R. Hicks; actually the product code I am using is international Hs code, consist of 8 digits, the first 2 digits refer to the chapter( chapter 7= vegetables, 8=fruits, 2 meat,..) and the second 2 refers to sub chapter, then to detail product), its important to consider this coding as basis for...

thank you R. Hicks for your kind respond; no its not the acctioal names, what I want is the total for vegetables sub group, the total for fruits sub grup, not at product level thanks majed

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