table and date question

[Former Member]

I have three tables and one ADD Command table that just pulls out date and result from another table in the database. All table are linked by date. When the report is run, the report stops on the last date with the last result. (ie the command table only has data in it until 10/29/2107 currently whereas the other table have data up till the end of the month) the report is only showing up to the 10/29 date and not displaying the rest of the days of the month just leaving the values empty for the add command linked table) Hope I explained this correctly.

Thanks

[Former Member]

Which way is data link running

Command should be on left and then joined to data with a left outer.

Check your filters and grouping make sure they refer to Date in command other wise dates in data tables will override links

[Former Member]

Change join to Command - make it a Left outer join

[Former Member]

Thanks, but that made no difference. report still stops on the last data that was entered in the table for the command.