Query to 2 decimal places

[arobbo]

is there an easy way to display the result of a query only to do decimal places where the query has a calculation in it without using a form.....

senario....

i've got a query that calculates a percentage and i would like to present it to two decimal places.....

anyone got any ideas??

 

[lupins46]

Right click the column fieldname in design view and choose Properties. Set the format you require.

 

[arobbo]

i'm not really displaying the results in a form as such but having a button on a form which runs the query which then displays it in a seperate window as such i can't change the way its displayed, i wonder if there is a way to just show the percentage to 2 dps in the query design or SQL screens.

 

[lupins46]

Which bit of my response was not clear? I never mentioned a form anywhere.

 

[SkipVought]

It's a QUERY, lupins46.

In the grid...
[tt]
Format([MyField], ,"#,###.00")
[/tt]


Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[lupins46]

I know its a query. What's the problem with my answer?

 

[SkipVought]

lupins46,

You're right. Sorry!

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[lupins46]

No problem! I must admit your response created doubts for a moment. But anyway, the Q'er has two solutions to pick from.

Regards

 

[arobbo]

Thanks for your help !!