Almost done...

[bbznyc]

Is it true that when you think your project is done - it's not even close to being over?!


Here is my list of questions:

On my orders page i have an unbound box which calculates [field1]+[field2]-[payments] to give total balance owed.

Q 1. How can I make a report to show which balances are still greater than 0?

Q 2. What is the best way to give the user an option to pick between between which dates they want the report to ran. (a pop up box?)

This is it for now... I will have more goodies later...


Thanks to all,

B Man.

 

[Kevin_S]

Q1: Create a new query. Put your fields (field1, field2, Payment) in the query fields. Then in a query field that does not have anything added to it yet add this: [field1]+[field2]-[payments] in the "Field" field... then in the crteria for this field put >0... then base your report off if this query.

Q2: See my calendar control demo locate here: Calendar Demo

HTH,
Kev

 

[bbznyc]

dude,

this is sick... thanks a lot!!!


why didn't i think of that???

 

[Kevin_S]

glad you liked it...

if you like the calendar demo check my demo for the treeview control in that same forum... lots of applications and uses for that one!

HTH,
Kev

 

[bbznyc]

guess what... i totally forgot to mention that I have multiple payments. What should i do then?

 

[bbznyc]

doh.... did it...