This is quite simple but im finding it quite hard to cum up with a solution
i have 2 select queries from one table which give me different results, i would like the results to come togther and add to another table
I have also done this as 2 seperate append queries which works fine but would be better if we could do in one whole!!!
the tables have the same format and same fields
how can i go about doing this???
thanks
i have 2 select queries from one table which give me different results, i would like the results to come togther and add to another table
I have also done this as 2 seperate append queries which works fine but would be better if we could do in one whole!!!
the tables have the same format and same fields
how can i go about doing this???
thanks
