queries

R

rexmann

Hi all

I have a couple of questions on queries.

HOw do I display a calculated field in a query to a set number of decimal
places (in the query I type field: [field1]*[field2])

How do I do a query that will search for a field that begins with a specific
letter or number (or ends with).

Any help appreciated

Cheers Rexmann
 
A

Allen Browne

Use Round() to determine the number of decimal places in the result of the
calculation, e.g.:
Round([field1]*[field2], 2)

Then in your form or report, set the properties of the text box to determine
how many are actually displayed, e.g.:
Format Fixed Number
Decimal Places 2

Regarding the partial match, use the Like operator with a wildcard in the
Criteria of your query, e.g.:
Like "C*"
 
R

rexmann

Hi Allen

thanks for your help

cheers Rexmann

Allen Browne said:
Use Round() to determine the number of decimal places in the result of the
calculation, e.g.:
Round([field1]*[field2], 2)

Then in your form or report, set the properties of the text box to determine
how many are actually displayed, e.g.:
Format Fixed Number
Decimal Places 2

Regarding the partial match, use the Like operator with a wildcard in the
Criteria of your query, e.g.:
Like "C*"


--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

rexmann said:
Hi all

I have a couple of questions on queries.

HOw do I display a calculated field in a query to a set number of decimal
places (in the query I type field: [field1]*[field2])

How do I do a query that will search for a field that begins with a
specific
letter or number (or ends with).

Any help appreciated

Cheers Rexmann
Click to expand...
Click to expand...
 
R

Russ

Where have you been all my ACCESS Life. Thanks for the help.

rexmann said:
Hi Allen

thanks for your help

cheers Rexmann

Allen Browne said:
Use Round() to determine the number of decimal places in the result of the
calculation, e.g.:
Round([field1]*[field2], 2)

Then in your form or report, set the properties of the text box to determine
how many are actually displayed, e.g.:
Format Fixed Number
Decimal Places 2

Regarding the partial match, use the Like operator with a wildcard in the
Criteria of your query, e.g.:
Like "C*"


--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

rexmann said:
Hi all

I have a couple of questions on queries.

HOw do I display a calculated field in a query to a set number of decimal
places (in the query I type field: [field1]*[field2])

How do I do a query that will search for a field that begins with a
specific
letter or number (or ends with).

Any help appreciated

Cheers Rexmann
Click to expand...
Click to expand...
Click to expand...
 
Top