Recent content by Jake

You need to modify the TableDef in order to change the field name. Try this code fragment(Access 97): Dim db As Database Dim tdf As TableDef Set db = CurrentDb() Set tdf = db.TableDefs("tablename") tdf.Fields("fieldname").Name = "newfieldname"

Change the line rstProjectName.ProjectName = NewData to rstProjectName!ProjectName = NewData or rstProjectName.Fields("ProjectName") = NewData

One option to calculate the response-criteria totals in one query would be to use "sum" instead of "count" in the query. For example, for the total of responses where q1="no", use this field (with total type = "sum"): Q1NoTotal: abs(q1="no") The expression (q1="no") will evaluate to 0 (false)...

Quite right about the joins in Query2, forgot to clarify that slightly important detail.

Unless you're trying to address this problem through the crosstab query itself, one option would be to fill out the non-values before using the crosstab: Query1: Add tables "tableStudents" and "tableProficiencies", unjoined. List (assumedly) StudentID and ProficiencyID. Each student will have...