Form created by crosstab query

  • Thread starter Thread starter LMB
  • Start date Start date
L

LMB

Hello,

Using Access 2000. I have looked on the web and it's probably not possible
but I'll ask in here anyway because the data entry person would really like
this to be the way she enters this particular data. I have a form based on
a crosstab query, I sure wish there was a way to update the records from
there. Any options? Thanks

Here is my sql code from the query since you guys can read that language a
lot better than I can explain it. <g>

TRANSFORM Max(TBLTestsAndCerts.TestsAndCertsTypeExpDate) AS
MaxOfTestsAndCertsTypeExpDate
SELECT qryNameAndSeniority.Name
FROM TBLTestsAndCertsTypes RIGHT JOIN (qryNameAndSeniority LEFT JOIN
TBLTestsAndCerts ON qryNameAndSeniority.strEmployeeID =
TBLTestsAndCerts.EmployeeID) ON TBLTestsAndCertsTypes.TestsAndCertsTypesID =
TBLTestsAndCerts.TestsAndCertsTypeID
GROUP BY qryNameAndSeniority.strLastName, qryNameAndSeniority.Name
ORDER BY qryNameAndSeniority.strLastName
PIVOT TBLTestsAndCertsTypes.TestAndCertsType;
 
You cannot update data from a Cross-Tab Query so the Form based on the
Cross-Tab Query is not updateable AFAIK.
 
Back
Top