M
Mary Fetsch
In my Access 2000 project, I need to show data from 2
tables in my form. I've set up a query as the record
source for my form. The query contains the following SQL:
Drop view TrxInquiry
Go
Create view TrxInquiry as
Select top 100 percent FILE_NUM from Table 1
union
Select top 100 percent FILE_NUM from Table 1
order by FILE_NUM
It's not ordering by FILE_NUM. If I delete the union and
second select statement, it works fine. If someone can
help me with this, I'll be very grateful.
tables in my form. I've set up a query as the record
source for my form. The query contains the following SQL:
Drop view TrxInquiry
Go
Create view TrxInquiry as
Select top 100 percent FILE_NUM from Table 1
union
Select top 100 percent FILE_NUM from Table 1
order by FILE_NUM
It's not ordering by FILE_NUM. If I delete the union and
second select statement, it works fine. If someone can
help me with this, I'll be very grateful.