Essentially I have a table of phone numbers and two columns: primary phone and secondary. Don't ask me why, but for maybe 15-20% of the entries, the primary phone field is empty and their number is in the secondary field.
Is it possible to have a query pull the secondary number into a the primary field if the primary field is blank? Or maybe create a whole new field which pulls in the primary and then pulls in the secondary if the primary is blank? Any suggestions?