Skip to main content
Question

Generate Invoice Report On Date Range

  • October 22, 2020
  • 0 replies
  • 41 views
Currently have the following table relationship:
Here are my invoice table fields:
I need to generate a report based on "ask user" input of "Start Date" and "End Date" range to include only the records that fit within date range.  There can be up to 12 Invoices created on the project at this time.  Each invoice has it's unique Invoice Date, Invoice # and Invoice amount. What is the best way to construct a report fitting this criteria?​

------------------------------
Philip Hall
------------------------------
This topic has been closed for replies.

Since your Invoices table is a child to the Project, you can have each Invoice be an individual record (and actually should do this), rather than having a single Invoice record with multiple dates, amounts, etc.

I would suggest changing your Invoice table to have just the following fields:
  • Invoice Date
  • Invoice #
  • Invoice Amount

Once you do this, you can use the Invoice Date field to build your report.​​

------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
Terms & ConditionsAccessibility statement