Search results

^ that worked perfect! Thank you

I do ASC and still get 43 records. I only want 1 record returned each time the query is run.

Thanks for your suggestion however the user wants it sorted oldest to newest so it has to be ASC sort.

Hello, I am hoping someone can assist me here. I have searched on the web and cant seem to find what the actual issue is. I have the following select statement: SELECT DISTINCTROW TOP 1 tblElectronicBilling.[PRIMARY FILE NAME], tblElectronicBilling.[Assigned To]...

My question is how would I accomplish this? This fits into my overal goal as this was a requirement that was added and I am not sure how to accomplish it, I have been told it can be done I just dont know how......

The problem is I am trying to calculate a % based on the fields that are populated. I know its a strange request but that is what is being requested. I am new to VBA and Access so please forgive me.

Hello Everyone, I am new to the board and fairly new to Access as well. I have been assigned a task at work to import an Excel spreadsheet into Access to utilize reporting functions/features. I am aware it would be best for it all to be done in Access however the business is not willing to move...