Browse By Tags

  • Row Level Permissions on Query Reports

    Hello All, I am trying to setup row level permissions on Query reports so that users can see data only specific to their site. I was able to setup the row level permission on all the transaction screens, but I am not sure how to setup similar permissions…
  • General ODBC Errors (Pass Through Queries) in Access 2016

    Hi all; I've been having some serious difficulty finding an answer to this issue, which has led me to create my first post here. I have an access database that pulls tables from all companies by use of pass through queries. Connection strings are handled…
  • How to Create a Crystal Report based on a Union Query for SO_InvoiceHeader + SO_InvoiceDetail to AR_InvoiceHistoryHeader + AR_InvoiceHistoryDetail

    I am trying to create a Crystal Report that unites the data from SO_InvoiceHeader + SO_InvoiceDetail to AR_InvoiceHistoryHeader + AR_InvoiceHistoryDetail. I believe the best way is to use a Union Query in Access and so I have created 1 Query for each…