Search results

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

I have a table similar to this table ----- ID field1 field2 field3 'ID' is the primary key but I want MS-Access to have an eye on field1-3 to avoid entering the same information into field1-3. How can I do this? (Using field1-field3 as primary keys is not desirable) Please help. Thanks in...

Hi there! If you think you can try this: http://www.access-programmers.co.uk/forums/showthread.php?t=103630 BR SzCs

Hi! http://www.access-programmers.co.uk/forums/showthread.php?t=103636 The last remark (on the bottom of the page) may be helpful. BR SzCs

Dear All, I put a database on the local net, and it is not allowed to start it directly, but you can enter it through a shortcut. How can I save it like a simple database without users&password? (When the database was put on the intranet a .bak was created automatically but in the meanwhile...

THX, it works.