Skip to Content
0

table and date question

Nov 02, 2017 at 05:23 PM

24

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Ian Waterman Nov 03, 2017 at 11:03 AM
0

Change join to Command - make it a Left outer join

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

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

0
Ian Waterman Nov 14, 2017 at 08:43 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded