Two Questions on Append query

[2wistd]

So I am getting data from another database and i have the table linked. Created a query and will append it to my main table. When I append them I want to have them all added as students. The other table doesn't have a field called 'students'. Is there any way I can add that field to my main table when appending the query? If so, how?

2nd question, same scenerio, but the table has a linked table to a class number, which that table has the start and end dates which I'd like to put into the main table as well. How do I get that information. The student table has a 'class number' field, which simply has a number. those numbers line up with class numbers with the dates. Can I join that information and then append?

 

[jdraw]

If you want focused assistance, you'll have to move away from this sort of "generic vague statement"

Created a query and will append it to my main table. When I append them I want to have them all added as students.

.

Start by giving us an overview of WHAT you are trying to do in plain English. Help us help you by telling us about your issue/opportunity in simple terms. Help us get oriented.

Post a jpg of your tables and relationships in zip format.

If you link to another database, why do you think you have to APPEND anything?