I would like to do a left join on the from Pymnt to Commission 3 times in MS ACCESS.
But no matter how I try, I can't get it right.
Table 1: Pymnt
PymntID Amt
1 10
2 20
3 30
Table 2: Commission
PymntID Type PCT
1 AGT 70
1...
hi,
I tried using a cross-tab, I can get the desired outcome except for the last two columns of formula. i.e. To display the bundles by grouping up the T and the W, and the Qty with respect to the length.
So, how do you put in the last two columns into the cross-tab?
NB: if you do any...
hi,
I need some help here.
I have a simple table with the following fields and data:
Table Name: Bundles
BdlNo T W L Qty
----- --- --- --- ---
1 1 2 7 10
1 1 2 8 10
1 1 2 9 10
2 1 2 6 10
2...
Hi,
I need to use ASP to develop a online form, and the contents collected by the form will be converted into a HTML file to be sent via email.
Any hints on how to go about achieving this?
Hi,
Need help urgently here.
I encounter an inconsistent error here.
Sometimes when I run the same report but with different paramenter values, e.g. Invoice number, when the CRViewer forms loads up and tries to display the report, the following error messages pops up:
1) Seagate Crystal...
Hi Moonmouth,
thanks for your reply, but this is not what I need.
I know that we can format number fields through the format field options. What I need is to be able to set the number field dynamically to the correct number of decimal place for each record retrieved.
e.g.
Rcd no. field value...
hi,
I would like to display a number field to the correct number of decimals at runtime.
e.g
1.0000 as 1
0.8750 as 0.875
0.5000 as 0.5
2.5000 as 2.5
how can I do that?
Cheers,
Eric Lye
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.