Help with query.

[serino]

Please help, not sure how to approach this..


I have two queries called BF140 and BF141 with the following fieds:

BF140_Query
[recnum].[costcde]
BF141_Query
[recnum].[costcde].

I would like to have a new query that would combine both queries into one query. The query would display all records from the combined query and only show one recnum field and one cstcde field.

 

[lespaul]

select * from BF140_Query
UNION
select * from BF141_Query



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases:
The Fundamentals of Relational Database Design
Understanding SQL Joi

 

[serino]

Hello Leslie and thanks for replying.


I am not familiar with SQL. How do I insert this into a new query?

 

[dhookom]

Open a new, blank query in SQL view and enter the statement suggested by Leslie. You may need to add a semi-colon at the end of the statement.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]