OHHHHHH That’s what AS is! I’ve tried using it to rename a table in sql, but never new it was a real thing.
I really appreciate you taking the time to respond. I spent a good 4 hours on it today and ended right back where I started. So, when I get to work tomorrow, I will most definitely take your example and see what I can get done with it. Tomorrow is the students’ submission deadline, and we have to compile results Monday. Thank...
j1s15n
Last Activity: Jan 14 '19, 08:50 PM
Joined: Dec 28 '18
Location:
-
Thanks for all your input! Yes, I am an extreme amateur when it comes to databases. I learn by doing and using examples people post via different threads. Unfortunately, being in the profession I'm in, I don't have a bunch of time to really get educated like I would love to do.
Regarding the fields, I can't change them because I pull the data from a website that a 3rd party runs for us. Here's what it's used for:
We...Leave a comment:
-
Unfortunately, the fields are set because I pull them from a website where individuals put in requests to exchange schools. I export the excel from the website, then import into the DB....Leave a comment:
-
Comparing data in multiple columns/rows in same table with query
I have a table that has 2 columns that I need the Database to match. I have a bunch of people that have listed what they have in one column and in the next column, they list what they want. I need the Database to tell me which ones match.
Johnny has an apple but wants an orange
Sally has an orange but wants an apple
Derek has a pear, but wants a banana.
In the above scenario, the Database would tell me...
No activity results to display
Leave a comment: