Search results

I wonder if this is possible? I have a tale named tCBZ that serves as a data source for the form named fCBZ. The table has several fields, including the Short_Name and Long_Name fields. On the fCBZ form, only the Short_Name field is used(because it is shorter:)). However, for some records the...

Thanx arnelgp. That's exactly what I wanted.

Hi arnelgp and thank you for your reply. Unfortunately, your proposed solution does not give the wanted results. I think I was not clear enough in explaining what I want. So I'll try to explain it again. I have a table with records like those in Table1. I would like to filter the records like...

Hi! Thank you for your reply. I had to prepare sample tables, which took me some time ... I uploaded a sample file with two tables. Table1 contains "original" records. Table2 contains records that I would like to get with the help of a query. Additional explanation of the wanted results: Case...

Hi! I have a table with the following fields: Group_ID Offer_ID Notes Total _ sum Selection I would like to build a query that would show only those records (Offer_ID) for each Group_ID that are not selected and for which the sum is less than the sum of the selected Offer_ID. Please...

Thank you plog and jdraw for your advice and solution. Exactly what I was looking for.

Hi! I have two tables. The first one, the tATC table, contains ATC codes and descriptions. As you can see from the attached access file, it has 5 levels of ATC codes. The second one, the tConsumption table, contains data on consumption of medicines, including the 5th level ATC codes. I'd like...

Thanx arnelgp, it works!

Hi Isskint and thanx for the tip. I made a query as you suggested, but it's not working as it should because it affects all records in the table and not only those it should. Yes, they are. The checkbox "MySelection" on the main form "fGroups" is bound to the table "tGroups" field...

Hi! I'd like to know how can I select/deselect the checkboxes for all records on the subform when I select/deselect the checkbox on the main form? I tried the code Private Sub MySelection_AfterUpdate() Me.Subform2.Form!MySelection1.Value = Me.MySelection.Value End Sub but this only select the...

Thanx, that is exactly what I was looking for.

Hi! I somehow can't find an easy option to view all my threads. Is there any other way to view my own threads than using advanced search option Find threads started by user?

Thanx for your answer sneuberg and sorry for my late replay. Unfortunately, your solution does not work correctly, because I get only one record displayed. However, with some modification of your first suggestion (which I didn't disregard) , I got what I wanted. I changed the first query...

Hi! I'd like to know how to build a query to get the results I want. I'm using access 2010. I have a table with the fields Group_ID, Item_ID, Item_Name and Quantity Group_ID Item_ID Item_Name Quantity 1B.05.BB.01.017 64572 First Item Name 0...

Sorry for late replay. I tried both suggestions and the first one is the right one for me. Thanks.

Thanks, but it doesn't do the trick because it shows all records without selection (see example2.jpg). I'll try to explain. If you compare example1.jpg and example2.jpg you can see that there are several Items with a Grup_ID 1A.01.AB.09.001 and different Price_Ranking. There is a selection for...

With regard to what I wrote in my thread, I'd like to use a query to filter out all Group_id that do not have any marked selection.

Hi! I use Access 2010 and have very little experience with it. I have a table with the following fields: Group_ID, Item_ID, Item_name, Item_price, Price_ranking, Selection (see Example1.jpg) The records are sorted by Group_ID and Price_ranking, where number 1 represents the lowest price. Each...

Thank you both, MarkK and plog for your answers. The plog answer is exatly what I was looking for.

Hi! I'm using Access 2010 and would like to do the following thing: In my database, I have two tables. One table is a list of items [ItemsTable1] and contains the following fields: Group_ID, Item_ID, Item_Name. The second table is a list of a group of items [GroupTable1] with fields Group_ID...