Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Creating a recordset

Status
Not open for further replies.
excalibur78

excalibur78

IS-IT--Management
Jan 3, 2001
66
US
I have a report in which is based on a date range. If this date range does *not* contain today's date it uses the history table. If it contains today's date it then needs to combine the history table and the active table into 1 recordset to display them together. Both tables are identical in structure except the history table has an ID since it has to allow dupes and active doesn't allow dupes. Can't seem to get it to combine the 2 tables into 1 recordset. Any help would be great.


Thanks,


David
 
Status
Not open for further replies.

Similar threads

B
  • Locked
  • Question
Difference of a field between 2 variable dates
Replies
1
Views
203
hilfy
hilfy
J
  • Locked
  • Question
New page before when a detail section last on page.
Replies
1
Views
408
hilfy
hilfy
D
  • Locked
  • Question
Running total from a subreport only showing last value
Replies
4
Views
547
doodledump
D
LauraW
  • Locked
  • Question
Format Numbers in a String
Replies
4
Views
430
LauraW
LauraW
SarahSCPDAdmin
  • Locked
  • Question
Can I format data in a memo field? 1
Replies
5
Views
312
SarahSCPDAdmin
SarahSCPDAdmin

Part and Inventory Search

Sponsor

Back
Top