Improving append query speed




I have an update query that works well and at good speed ONLY IF I use a
single field in the append query, such as "LastName". But my pull down combo
boxes have the follwing expression: Expr1: [LastName] & ", " & [FirstName] &
", " & [Position], which allows the user to choose the right student (many
same last names). So, I have also put the same expression in the append query
as well. This slows down the append query dramatically.

Any way to have a single field in both combo boxes and the append query AND
still have the LastName, FirstName & Position appear on the combo boxes?

The append query SQL coding just in case it helps:

SELECT DISTINCTROW [LastName] & ", " & [FirstName] & ", " & [Position] AS
Expr1, [Course Details].CourseID, [Course Details].Material1, [Course
Details].Material2, [Course Details].Material3, [Course Details].Material4,
[Course Details].Material5, [Student DataBase].Company, *
FROM [Student DataBase] INNER JOIN [Course Details] ON [Student
DataBase].Company = [Course Details].Company
WHERE ((([LastName] & ", " & [FirstName] & ", " &
[Position])=[Forms]![Search Students for New Class]![cmdLastName1] Or...

Thanks very much in advance.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question