ms query

[dreadnaught]

I have two tables that carry the same information but on is last six month the other is the historical file with data beyond the six month range. When pulling data I have to create two queries one for each table. Is there a way in MS Query to pull both tables at once and have them both populate the same column?

 

[rporubski]

Not that I know of, I tried the same thing not with dates though. It seems the only way to make that work would be to create a vb statement. Don't exactly know how, it is kind of technical, might want to consult one of your vb programmers.