Okay, I haven't had much success finding solutions on this board lately, but hopefully there is someone out there that can help me ray: Here is a sample of my code:
strSQL = "SELECT * FROM [Employee Snapshot] WHERE [super] = 50052594"
"50052594" is stored in a number field. How can I substitute 50052594 with rsCriteria![Super] to make this code dynamic?
strSQL = "SELECT * FROM [Employee Snapshot] WHERE [super] = 50052594"
"50052594" is stored in a number field. How can I substitute 50052594 with rsCriteria![Super] to make this code dynamic?