Recent content by hunoob

Wow! Just wow! Finally I was able to understand your point and I was able to break down the queris in query objects and then reference them in one main query. And it works just the way I wanted! Thank you soooo much for your help! You're a real lifesaver! Thank you so much!

Dear plog Sorry for being away but meanwhile I received a very urgent project and I also was on holiday therefore I could not work in this issue. However now I am back and as this script is still not running I have to keep working on it. Thank you for your reply first of all. I tried to run...

Dear plog! Thank you very much for your help! Indeed I have a call id field and it is named CallID. :) I tried to rewrite the scirpt according to your suggestion and I came up with the following: SELECT tbl_client_data.ClientID, tbl_client_data.Nev, tbl_client_data.Telefon...

Hi Everyone! I am quite new to Access/SQL and I hope you can help me. I have two tables: tbl_client_data tbl_calls The clientID is the foreign key in the tbl_calls. I make a search on the clients and their respective calls. Of course one client can have many calls (not the other way around)...

Hi michaeljryan78! Thank you very much for your help! Actually I wanted to have it grouped by the risks, so I tried to make the adjustments...but failed in succeding. What I would like to have is this...

Hi there Everyone. I hope you can help me with this problem. I have three tables. Risk, Names and RiskAndNamesJunction table. I have the junction table because I have many to many relation (meaning many people can be connected to one risk and many risks can be connected to one people)...

Hi Everyone! I have solved the problem! :) What I did is I created a junction table. In the junction table I put the RiskID and RiskOwnerID codes. And connected them to the relevant table ID fields. This way I can have many owners to many risks. Thank you for your help!

Hi Pat Hartman. Thank you for your reply. I have multiple owners but in the trial file I just put two. I thought if I can manage with two I will be able to manage with more than two as well. As I am a beginner it is hard for me to understand clearly your help. Could you please somehow attach...

Hi Mihail! Thank you for your reply in my other post. I do no think that this is a double post. It is a totally different problem. The topic is also different. And this problem is still not solved. :(

Hi Mihail! Thank you for your reply. I will remake my database structure.

Hi there Everyone! I have a very big problem, and I do not know how to solve it. I have a risk table containing risks and risk owners (many owners for one risk), meaning that I have two risk owners columns. What I would like to do is to connect both risk owner columns (containing the name IDs)...

Hi plog! Thank you for your reply. I will try to change it, however I do not know how will I be able to input the names if I can see only a the Name_Azonosito id number. :(

Hi Everyone! I am pretty sure that my problem is very basic, and probably it is about connecting tables the right way, however the end result I would like to see it in a query. So here is my problem which is driving me mad. I have two tables: one contains the risks and the riskowners, the other...

Isn't there really anyone who could help me with this? Is it so hard / impossible to make it? :-(

Hi there Everyone! I have a problem and I just can't figure out the solution for it. Please try to help if you can. Actually the problem has two major parts: 1. I have a table (please see the attached file) with three columns. An autofield, a "Code" column and the "Description" column. The...