Recent content by xxyy

Hi EMP, Thanks for your help!!! This is exactly what I wanted!!! GBY! xxyy

Hi, Sorry for my bad English & wrong terminology... I would like to get only UNIQUE values for flield "city". This is what I would like to achieve. Thanks, xxyy

Hi, This is a simple select query. How can I get such a result where I can see London, Washington, etc ONLY ONCE - though there's several records with London, Washington, etc. I'm examining a simple select query and I can't figure out how it is solved. I can't find the setting.... Please help...

Dear Access experts, Please help... I have a table like this: Name_City XY___London YX___Washington ZZ___London SS___Chicago AA___London ... How can I achive by simple setting to get all the Cities once? (I've solved this through 'group by' but there's another function in Access to do...

Dear All, How can I use week instead of month? There's no 'week' built-in function (there's 'month' function) thx xxyy

Dear MStef, Your solution is quite simple, thank you! BR xxyy

Dear All, I'd like to solve the following problem. I have a table similar to this: material1_date1_qty1 material1_date2_qty2 ... material1_date9_qty9 ... materialN_dateX_qtyW I'd like to define categories for date (e.g. month) and summarize the quantities: material1_period1_qty1+2 (if...

Dear Denisk and Jal, thank for your help!!!

Hi Dennisk, Sorry, I'm just beginner. On the property sheet I found the following entries: description format input mask caption smart tags + display control Maybe I didn't use the property sheet you mentioned. Could you help please how/where to set the 'unique' property for output rows...

Dear All, I have a table with several fields. Concentrating only on few fields I'd like to sort out redundant information (unnecessary records). (It is similar to using Ecxel: Data>Filter>Advanced filter>Unique records only) So, I'd like to ask for your help how can I reduce my table to...

MStef & rak, thank you! It works. MStef, Sorry, you're right. I didn't follow properly your instrucions. BR xxyy

Thanks for your reply. I created the query, but something doesn't want to work. (I can get the result I want as pivot table but if possible I'd like create query for it). My test database is attached. Please check it. thx xxyy

Dear All, I'd like to ask for your precious help. I have a table of the following fields & tructure (simplified): part number; date; qty; A 01 5 A 06 12 B 03 3 B 08 29 ... My aim is to get a list of maximum qty...

Thanks, that's what I wanted to use. Only a little problem: I have a field that doesn't contain any value and I couldn't set the m-index to work properly (zero length didn't help). BR xxyy

Dear TanisAgain, Thanks for your reply. The problem is that a field (e.g.field1) can contain the same data many times but field1+field2+field3 together aren't allowed to contain the same data. allowed: field1 field2 field3 x y z x y zw not allowed: field1 field2 field3...