Cross join to create ledger type query from 4 tables (1 Viewer)

Ramnik · Apr 2, 2013

hello everyone ,
i have 4 queries in which data needs to be connected from the date and shown as a single date showing each sections entry in a row and a cumulative total is maintained as the balance .
Kindly see the attached image
thanksss

Ramnik · Apr 4, 2013

isn't it possible ??????????

JHB · Apr 4, 2013

Do you have some sample data, (in table or spreadsheet), from the 4 tables?

Ramnik · Apr 4, 2013

this is the temporary report i have created ...
dates from all four sections need to be mapped and a ledger like report is needed with cumulative balance shown as i have previously asked ..
thankssss

JHB · Apr 4, 2013

The data you show do not have any corresponding dates, so ...!

Ramnik · Apr 4, 2013

does it really matter ????? they may have common dates or may not have ....
but it should show zero for the uncommon dates and common date's data is put on one row .... ya that particular product might not have it but that's not the point .
you can take any common dates for illustration ...

JHB · Apr 5, 2013

You can use a Union query to set the data up in "Add1", "Add2", "Rej1", "Rej2", then a second query to sum the data together, and then a third query to make the running sum. Maybe you can "cook" the queries down to two.
I've made an example in the attach database, run the query "QueryRunningSum".

Ramnik · Apr 5, 2013

that was just toooo good ....
Thanks for helping brother , i will implement this logic . didn't knew it before . awesum stuff...

Cross join to create ledger type query from 4 tables (1 Viewer)

Ramnik

Registered User.

Attachments

Ramnik

Registered User.

JHB

Have been here a while

Ramnik

Registered User.

Attachments

JHB

Have been here a while

Ramnik

Registered User.

JHB

Have been here a while

Attachments

Ramnik

Registered User.

Similar threads

Users who are viewing this thread