Hi Guys I need Help to turn this query Formula into a function that saves the results to a table.
The table name is ZHTCalc and the field is SeqID.
The formula is
SeqID: DCount("*","ZHTCalc","CoverID=" & [CoverID] & " AND SortID<" & [MovieID])+1Any Advice would be appreciated