Formatting the field in a querry result.

Formatting the field in a querry result.

Post by Mari » Fri, 22 Aug 2003 23:31:32


Is there a way to format a field as currency i.e, a
column in querry result to have a Currency symbol in the
front.

In querry's design view I tried right clicking in the
field then properties and format., the drop down box is
empty.

Any help is hightly appreciated.

Thanks
Manik
 
 
 

1. Presenting Querry Results in a tabular format; export to Word

2. Copy all data from a:Class A's fields to the namesake fields of b:Class B.

I have two class with nearly exactly same attributes, the only difference is
class B's property setter does some argument checking.

[Serializable]
class A
{
private string a;

public string AA
{
get { return a; }
set { a = value; }
}
}

[Serializable]
class B
{
private string a;

public string AA
{
get { return a; }
set
{
if (string.IsNullOrEmpty(value))
{
throw new ApplicationException();
}
a = value;
}
}
}

I want to do the following:
A a = new A();
a.AA = "123123";
B b = (B)a; -- Copy a's attribute values to b.
Please tell me how to implement a generic function to support copying
namesake fields from one class instance to another even when they belongs to
different class type.

Thanks.

zlf

3. formatting Q and A's

4. How to insert "Manual Line Break" in querry results.

5. How to get result of querry independet of a datatype?

6. Querry giving incorrect result

7. identical querry with same data, but different results.

8. Querry giving incorrect result

9. Format a date field in database results region

10. AD Groups-Notes (info) Field - Searching AD and returning results in nice format

11. Database results format field

12. Access Database Results - Format FrontPage field as currency

13. format db results date field

14. Formatting specific parts of field results

15. Formatting a field result in Word