linking 2 query to 1 form (with filtering)

[cihow81]

Hi all,

I have created 2 queries to filter information from a table. This table consists of all date. reporting month, customers ID(local and foreign), spending amount (local and foreign currency). The first query consists of date, reporting month, customer ID, customer name and amount spent. the second query consists of date, reporting month, foreign customer ID, foreign customer name and amount spent in foreign currency. The first query is to filter local customers and the second query is used to filter foreign customers. I would like to do a month-to-month analysis of the spending amount of certain group of local and foreign customers in one single form.

any advises?

Thanks.

 

[bob fitz]

Can you show us the sql of both queries