Search results

  1. B

    Results Grouped in Accounting Month, not Calendar

    I am trying to be able to group columnar results by accounting month or by calendar month in reports/queries. User gets popup form and clicks on start and end month, as well as 'Accounting' or 'Calendar'. The trade date on each record is compared to the underlying calendar table of the...
  2. B

    combo box correct @ home, not @ work

    I have 2 combo boxes. Ater an entry is made in the first, the second requeries and displays relevent choices. This works on PC @ work, but when I e-mail it home to use, the second box display does not show the entry when I go in to change or view data, yet the table was updated correctly. Any...
    • BHill
    • Thread
    • Replies: 1
    • Forum: Forms
  3. B

    Where Clause in ComboBox keeps changing

    6 hours spent. Doing something dumb. Pulling my hair out. Any ideas? TblClients contains pkClientID TblAccounts contains pkAccountID TblClients has 1-to-many relat. with TblAccounts This part works: In Add mode, client opens frmOrders, picks a client (say TST) from list displayed in...
    • BHill
    • Thread
    • Replies: 2
    • Forum: Forms
  4. B

    Calendar vs Accounting Dates

    I new at this, trying to keep writing code to a minimum. I need to be able to generate queries and reports based on an accounting month (ie the month ends 3 business days before the last business day, assuming no holidays) in addition to queries/reports based on calendar month. I created a...
Top Bottom