View Single Post
  #4 (permalink)  
Old February 11th, 2005, 08:45 AM
rjweers rjweers is offline
Friend of Wrox
Join Date: Nov 2004
Location: Seattle, WA, .
Posts: 248
Thanks: 0
Thanked 1 Time in 1 Post


To get the data you want, you could use a union query. E.g. (Not exact syntax)...

Select ID, Substation, Recloser, TypeRating, 1 as SetOrder From tblParent
Select Id, Substation, Indicator, FourthColumn, 2 as SetOrder From tblChild
ORDER BY SetOrder;

Not sure about there being a fourth column to your child. If not, just use Null instead of FourthColumn.

Are you using MS Query to fetch the data from Access? If so, you might want to create a temporary table out of this suggestion. Just change the above to an Append for your table. I've found that MS Query doesn't use union queries well. But the nice thing about MS Query is that you can refresh your Excel sheet without writing code.

Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group