Code Problem

[senia97]

I was wondering if someone can help me out with a code. I am trying to calculate the balance from a query feild by a Year To Date amount in a table feild in its own column in a new query. I have the Query joined with the Table ready to start but I can not figure out how to start the code to calculate these two feilds. The actual calculation is ChargeOffBalance/YTDFunding = % of total amount funded. The table I am pulling the YTDFunding feild from is called FranVol04 and the Query I am pulling the ChargeOffBalance feild from is called DealerChargeOffs. Can some one help me?

 

[flyover789]

you can use a query expression like

[ChargeOffBalance]/[YTDFunding] as [% of total amount funded]

please post the sql of your query, if you have further problems.

HTH,
fly


[blue]Typos, that don't affect the functionality of code, will not be corrected.[/blue]

Martin Serra Jr.

http://www.mserrasystems.com

[blue]Shared Database_Systems and _Applications across all Business_Areas[/blue]

 

[gnanas]

Hi,

Date field called "Notifiedtime" gives date and time I wish to format this field to give me year and month only
(200501 for january 2005) How can I format the field Any help would be very much appreciated

Regards

 

[PHV]

Format([Notifiedtime],'yyyymm')

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886