Thks hansfousert… i haven't hadthe time to try out…
Will update you the outcome :D
Date
Votes
2 comments
-
Jet Reports Historic Posts Suppose that I have 2 tables storing students details, student1 and
student2. (Fields: StudentNo, name, dob).
I wish to list the student no. from the 2 tables and sort by their date
of birth. How can I do this in Jet Reports.
I reckon I should use Union to merge the 2 tables. But how to sort it
by their dob afterwards.
I was told that it is not possible and being advised to retrieve the data from each table respectively.
Once that done, combine the data together and use Excel Filter to sort accordingly
Does anyone has a better idea??? -
Jet Reports Historic Posts Hmmm… interesting challenge you've got there for us, LegacySubaru…
How about combining the date of birth and student code into 1 field before using the union? I'm thinking of
=NP("Union",NL("Filter","Student1","=NF(,""DoB"")&NF(,""StudentNo"")"),NL("Filter","Student2","=NF(,""DoB"")&NF(,""StudentNo"")"))
Maybe you should use a format to get the date in a YYMMDD format for sorting purposes.
What do you think? Could that work? I'm very interested to hear about the result.
Please sign in to leave a comment.