Selecting the first and last record (Min/Max)

[Ste4en]

I have uploaded a tiny database which illustrates the question. I have a series of welds, in the example there are 6, numbered 1 - 6. I want a report which only shows the first and last weld details. I made two queries, one with MinofWeldNo and one of MaxOfWeldNo. Then a Union query to bring the first and last together.

But it does not work.

Please help.

Thanks

 

[Jon K]

See query "qryTwo" in the database.
.

 

[Ste4en]

that works, Thanks