Search results

  1. J

    Using DMax for Finding Highest Date of Order

    Hello everyone! I am currently building a system to track advertising in a newspaper. I have the following tables (that relate to this question): tblContracts, tblOrder. There are related by ContractID. The order has an advertising date for each line item... as such, one contract can have an...
  2. J

    Run Report with Query and Comboboxes from Multiple Forms

    Hello! I am working on an invoicing and receivables system and have one invoice report that is generated from one query (qryInvoiceMain). Now, the query is generated based on a control on a form. The issue arises as the criteria can be either from one form or another, only one of which is open...
  3. J

    Date Criteria from Combobox

    Hey everyone! I am stuck on an issue with my db. I am trying to run a query with data from multiple tables based on a date selection in a combobox. When entering the date on the criteria design (#9/16/2008# for example) the query runs fine. However when trying to run the same query with the...
  4. J

    Subform Filter based on Multiple Comboboxes

    Hey! So, I am having an issue getting a sub form to filter based on selections in a few combo boxes. The issue I run into is when trying to sort by a defined value for "year" and one of the multiple items of status, i.e. "<All Open>". The filter for "<All Open>" returns the incorrect values...
Back
Top Bottom