Linking 2 queries

  • Thread starter Thread starter Colin Coleman
  • Start date Start date
C

Colin Coleman

Newbie Question:

Is it possible in Access 2003 to have a query dependant on another query ?


If So how do i do it ?


Background:-
I have a table of customers and house numbers, and need to create a report
that lists on each SINGLE line a list of the house numbers in a street
seperated by "-", in say a memo or text field.

I have been able to create a "Normal" query that lists all the towns then
Streets then house numbers one line after the other in a report, but i need
to produce it on a street by street basis, EG:
Smallville
1st street 2-5-56-765-656-545-4355-4545
2nd street 4-6-7-88-54-323-543-6545-9458
ETC...
I seem unable to sus out how in the report generator how to on each detail
band fire a query with the parameters of the reports field Eg Town,Street
and then to open it , extract the street numbers , simply add them into a
string and then stuff them on to the report......sounds
easy?.....................how?

Regards Colin
 
Back
Top