i have 2 queries totaldues and totalPayments
totaldues has 2 fileds(custID (Group By)
amountDue(sum of all invoices dues)
and totalPayments consist of CustID(Group By) and Amount_Paid(sum of
thses queries calculate total dues and total payments customer made.
then i have another query on the base of these 2 queries which is
called custGrandBalance and it consist of customerID,amountDue(which is
sum of all dues about this customer), Amount_Paid(sum of all payment),
this query brings me total dues for the customer. Now problem starts
here that if i have amountDue > 0 but amount_Paid is nothing that means
customer never made any payment then this query will show me blank
record. for some reason. but if i put any payment in payment table then
i see the result. can any one help why is that. If there is no record
in query totalPayemnts then it should be equal to 0 which is not
is there any way if amount_paid has no value, when we run the query,
then we could put it equal to 0
Side Note: Please be more discriptive with your thread titles. The fact that you are posting a thread implies you need help. Therefore a thread title stating "HLP PLZ" is redundant. A lot of people ignore those kind of titles...
great help thanks man, i have solved my problem, god bless you. can you answer me one more question. How to take automatic backup of my database at certain time. I want to save only my data in the table on a backup drive or some other drive can you help plz
There is quite a variety of ways to do this. One of my personal favorites is another db with an autoexec macro (well, I use a little vb6 executable, same difference) that opens your target db and dumps all of it's tables to an xml or excel file. I then use windows scheduling to launch my "backup" application. How do you envision your desired process working, in general?
He specifically mentioned wanting data only. I used this method in a scenario where a seperate process would look at the file I was dumping too and cull differential backups to a data warehouse facility. There aren't many reasons to pull ONLY data from access when backing it up, but they exist.