Search results

Yes I am using 2007 Access. Sorry about that. I have it sorted by Date which is the way I like it but would also be nice to switch on the fly. John

I have a report that sorts by Date and also has Job_Name field. I want to know if you can sort the report by Job Name while the report is open by clicking on the header label for Job Name. If so how would the code look. John

You guys are great. I just didn't know the command and it works great. Thanks so much. John

Access 2007 I have a Quote table which has the Quote_ID field. When I do a report listing the quoted jobs I would like to click on the Quote_ID and have it open a scanned PDF file of the quote. I know how to do this using the Hyperlink Data Type but Quote_ID is a number and I don't want to...

You are the man! That worked great. Thank you so much. John

I have a table named Quote_Info. Within is a field named Customer_ID (which looks up the Customer_Name from the Customer_Info table). There is als a Contact_ID field which would look up the Contact_ID from the Customer_Contact table. Each customer can have several contacts. This is what I am...