Ordering View

M

Mary Fetsch

In my Access 2000 project, I have a screen where ther
record source is data from 2 tables. I've created a query
with this SQL statement:
Drop view TrxInquiry
Go
Create view TrxInquiry as
Select top 100 percent FILE_NUM from Table1
union
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ordering Query 0
Forms drop-down box does not list all db rows 2
Union query not displaying select statement 1
Trying to save a SELECT statement as the Record Source for a Form 5
What's wrong with the syntaz of this statement? 3
Using DSUM to get running total on a filtered form 0
Query to populate combobox with names of tables, only if they contain data 2
ComboBox RowSource UnionQuery 1

Top