Hello, I'm brand new. I'm looking to create a query to prep some data for a cross tab.
I have a file of students who took two certificate programs and it is structured like this.
StudentID Fname Lname Certificate CertDate 101 John Smith Marketing 2/1/2017 101 John Smith Accounting 5/4/2016 102 Jane Price Design 3/1/2015 102 Jane Price Project Management 3/1/2015
I would like to tack on a number column with a value for each certificate so I have values that I can convert to column headers in a crosstab. Date would be nice to use for the order (determining which gets tagged CertificateOne or CertificateTwo), but it isn't necessary, just as long as I can get the two certificates for each student on one row. It may also be a problem when the CertDates are the same.
StudentID Fname Lname Certificate CertDate CertificateNumber 101 John Smith Marketing 2/1/2016 CertificateOne 101 John Smith Accounting 5/4/2016 CertificateTwo 102 Jane Price Design 3/1/2015 CertificateOne 102 Jane Price Project Management 3/1/2015 CertificateTwo
Thanks in advance for any direction.
jezi