Multiple columns of data on the same report based on different dat

Multiple columns of data on the same report based on different dat

Post by S0FSTCBERV » Sun, 15 Jun 2008 05:42:00


You need subreports. The first three in one report and the last two in their
own subreport.
But first it sounds like you need to do some testing.
You need to test if Access will accept these as valid dates.
Build a select query for the first like this --
SELECT [YourDateField], Format([YourDateField], "mm") AS Month_of_date,
Format([YourDateField], "mm") AS Year_of_date
FROM YourLinkedTable;

Do the same for all linked date fields.

Post the table names for those fields you indicated --
SalesOrderLine.Amount
? ShipDate
InvoiceLine.Amount
? TxnDate
--
KARL DEWEY
Build a little - Test a little
 
 
 

Multiple columns of data on the same report based on different dat

Post by Bret » Sun, 15 Jun 2008 05:57:45

SalesOrderLine.ShipDate

InvoiceLine.TxnDate

 
 
 

Multiple columns of data on the same report based on different dat

Post by Bret » Sun, 15 Jun 2008 08:34:06

Sorry, Access doesn't let me save the select statement you have
posted.
 
 
 

Multiple columns of data on the same report based on different dat

Post by Uy5DbGFya » Fri, 20 Jun 2008 22:51:04

I would create a form to gather the user desired criteria. Then call the
report to specify the month.

Using the OpenReport method/action and set the Where parameter to filter the
data

"Month([FieldName])=" & cboMonth

Where the combobox cboMonth is bound to values 1-12.

--
Steve Clark,
Former Access MVP
FMS, Inc
http://www.yqcomputer.com/