G
gupta_rahul
Guest
I am tryin to expand data from my queries.
i have a query which gives me the following data from multiple countries,
ie.
country name, no of agents, supply, returns, week and day
now what i want to do is when i get these results,i want to expand them, ie. click on one of the country's name and get the details of the various agents for that country. for eg, click on ireland and check each agents supply and returns for the corresponding week and day.
I tried putting this data from a query to a form, and (somehow) managed to hyperlink it open a query on mouse click... what i could not manage is changing the criteria of the query to that of the form.
ie. specifyin what country,what week and what date.
Would Anybody know how to do this? also anybody with any suggestions as in what would be a better way to do this. im fairly new to access and my knowledge is limited.
thanks
i have a query which gives me the following data from multiple countries,
ie.
country name, no of agents, supply, returns, week and day
now what i want to do is when i get these results,i want to expand them, ie. click on one of the country's name and get the details of the various agents for that country. for eg, click on ireland and check each agents supply and returns for the corresponding week and day.
I tried putting this data from a query to a form, and (somehow) managed to hyperlink it open a query on mouse click... what i could not manage is changing the criteria of the query to that of the form.
ie. specifyin what country,what week and what date.
Would Anybody know how to do this? also anybody with any suggestions as in what would be a better way to do this. im fairly new to access and my knowledge is limited.
thanks
