wrting query to get result

[cliff]

My main table is [tloto select count] and its data catagories into groups and
groups are alloted value on certain basis and value stored in translation
tables name like slotogr,[int+mod] etc.,
table [tloto select count]
n1 n r latest
12 2 3 1/6/2008
14 6 5 15/6/2008
23 2 5 23/6/2008
35 4 8 2/8/2008

table slotogr
n1 tot
12 1
14 1
23 2
35 2
table [int+mod]
r ns
3 1
5 2
5 2
8 3

I have following individual queries to retrieve value for particular period
and working perfectly.
first :-
SELECT n1, n, latest, slotogr.tot
FROM [tloto select count] INNER JOIN slotogr ON [tloto select
count].n1=slotogr.n1
WHERE ([tloto select count].latest)>=[Enter Staring date]
ORDER BY slotogr.tot, latest;
second :-
SELECT n1, n, latest, [int+mod].ns
FROM [tloto select count] INNER JOIN [int+mod] ON [tloto select
count].r=[int+mod].r
WHERE ([tloto select count].latest)>=[Enter Staring date]
ORDER BY [tloto select count].n DESC , [int+mod].ns, latest DESC;

But instead of writing two different queries how can i put into one queries
may be by using combo box or list box or any ways .

please help to solve this

thanks

 

[andrew]

If I have understood you correctly, I think you could do this:

SELECT n1, n, latest, slotogr.tot, [int+mod].ns
FROM [tloto select count]
LEFT JOIN [int+mod]
ON [tloto select count].r=[int+mod].r
WHERE ([tloto select count].latest)>=[Enter Staring date]
ORDER BY ...

By the way, I would strongly recommend removing all spaces, + signs etc.
from your table and field names.