Search results

  1. R

    3 most recent dates

    I'm trying to pull the three most recent dates for student's courses they took in a specific content area. I already have the content area covered. My data includes a date for each course in this area but each student could have taken courses on many different dates and could have taken more...
  2. R

    Deleting and Appending data in a table from a separate database

    Thanks All These posts were very helpful and gave me exactly what I needed. Using your tips, I was able to delete the data in the table and then add the new data to that same table from the other database via a query without any problems. :)
  3. R

    Deleting and Appending data in a table from a separate database

    Thanks, I think we're on the right track. Let me add some details. I need the data in all the fields in table A, database A to be deleted and then append all the fields in Table A, Database A from Table B, database B. Does this change your solution? thanks
  4. R

    Deleting and Appending data in a table from a separate database

    I'm trying to delete data in a table, say Table A, Database A, from another Database, like Database B. I hope to delete the data then "append" the data once the data has been cleared. I know how to do it within a single database through the use of delete and append queries and running them...
Back
Top Bottom