Expression Builder help.

V

Vicki0323

I have an access question. On a test I am giving this is the question:
What I don’t understand is the ! between the
Round([FinesbyType]![SumOfOwed],0) What does the ! mean? Thanks,

Vicki
THIS IS THE QUESTION: 26. A new query has been partially written based on a
previously written query, FinesbyType. This new query will take this
information and round the fines owed to the nearest dollar. Complete writing
this query using the Expression Builder tool and Access' built-in functions.
THIS IS THE ANSWER• Using the Menu
1. Click on the Field row in the next available blank column on the QBE grid
2. Launch the Expression Builder: (1) Click on the Access toolbar Expression
Builder button (2) Right click from the Field row of empty column and select
Expression Builder
3. In the top pane type in the formula: Round([FinesbyType]![SumOfOwed],0)
4. Click the Ok button
OR DO IT THIS WAY:

Using the Menu (2)
1. Click on the Field row in the next available blank column on the QBE grid
2. Launch the Expression Builder: (1) Click on the Access toolbar Expression
Builder button (2) Right click from the Field row of empty column and select
Expression Builder
3. On the bottom half of the Expression Builder window on the left side,
double click on Functions. Then click on Built-In Functions. This will bring
up a list of Categories in the center section and function names in the right
most section.
4. Click on the center section and select either Math or All. Then in the
right most section scroll down until the Round function appears.
5. Either click on the Paste button or double click on Round to add it to
the expression box in the top third of the builder.
6. Click on the <<number>> argument in the expression in the top pane of the
Expression Builder
7. The number to be used is the SumofOwed field in the FinesbyType query.
Select this object by first clicking on the bottom left most pane and double
clicking on Queries.
8. Still using the bottom left task pane, scroll down and select (single
click) on the FinesbyType query.
9. This will bring up the field names currently saved in the query. Select
SumofOwed from the center section by double clicking or clicking on Paste.
10. Click on the <<precision>> argument in the expression in the top pane
and substitue with a 0.
11. Click the OK button to close the Expression builder.
 
V

Vicki0323

Actually it is on an exam I made and I dont understand the answer given on
the software. I dont understand the "!" I have never seen that before. (I
teach Microsoft Office...beginning)

KARL DEWEY said:
This sounds like a homework question.
--
KARL DEWEY
Build a little - Test a little


Vicki0323 said:
I have an access question. On a test I am giving this is the question:
What I don’t understand is the ! between the
Round([FinesbyType]![SumOfOwed],0) What does the ! mean? Thanks,

Vicki
THIS IS THE QUESTION: 26. A new query has been partially written based on a
previously written query, FinesbyType. This new query will take this
information and round the fines owed to the nearest dollar. Complete writing
this query using the Expression Builder tool and Access' built-in functions.
THIS IS THE ANSWER• Using the Menu
1. Click on the Field row in the next available blank column on the QBE grid
2. Launch the Expression Builder: (1) Click on the Access toolbar Expression
Builder button (2) Right click from the Field row of empty column and select
Expression Builder
3. In the top pane type in the formula: Round([FinesbyType]![SumOfOwed],0)
4. Click the Ok button
OR DO IT THIS WAY:

Using the Menu (2)
1. Click on the Field row in the next available blank column on the QBE grid
2. Launch the Expression Builder: (1) Click on the Access toolbar Expression
Builder button (2) Right click from the Field row of empty column and select
Expression Builder
3. On the bottom half of the Expression Builder window on the left side,
double click on Functions. Then click on Built-In Functions. This will bring
up a list of Categories in the center section and function names in the right
most section.
4. Click on the center section and select either Math or All. Then in the
right most section scroll down until the Round function appears.
5. Either click on the Paste button or double click on Round to add it to
the expression box in the top third of the builder.
6. Click on the <<number>> argument in the expression in the top pane of the
Expression Builder
7. The number to be used is the SumofOwed field in the FinesbyType query.
Select this object by first clicking on the bottom left most pane and double
clicking on Queries.
8. Still using the bottom left task pane, scroll down and select (single
click) on the FinesbyType query.
9. This will bring up the field names currently saved in the query. Select
SumofOwed from the center section by double clicking or clicking on Paste.
10. Click on the <<precision>> argument in the expression in the top pane
and substitue with a 0.
11. Click the OK button to close the Expression builder.
Click to expand...
Click to expand...
 
K

KARL DEWEY

It is a separated in a SQL statement between table and field or query name
and field.
--
KARL DEWEY
Build a little - Test a little


Vicki0323 said:
Actually it is on an exam I made and I dont understand the answer given on
the software. I dont understand the "!" I have never seen that before. (I
teach Microsoft Office...beginning)

KARL DEWEY said:
This sounds like a homework question.
--
KARL DEWEY
Build a little - Test a little


Vicki0323 said:
I have an access question. On a test I am giving this is the question:
What I don’t understand is the ! between the
Round([FinesbyType]![SumOfOwed],0) What does the ! mean? Thanks,

Vicki
THIS IS THE QUESTION: 26. A new query has been partially written based on a
previously written query, FinesbyType. This new query will take this
information and round the fines owed to the nearest dollar. Complete writing
this query using the Expression Builder tool and Access' built-in functions.
THIS IS THE ANSWER• Using the Menu
1. Click on the Field row in the next available blank column on the QBE grid
2. Launch the Expression Builder: (1) Click on the Access toolbar Expression
Builder button (2) Right click from the Field row of empty column and select
Expression Builder
3. In the top pane type in the formula: Round([FinesbyType]![SumOfOwed],0)
4. Click the Ok button
OR DO IT THIS WAY:

Using the Menu (2)
1. Click on the Field row in the next available blank column on the QBE grid
2. Launch the Expression Builder: (1) Click on the Access toolbar Expression
Builder button (2) Right click from the Field row of empty column and select
Expression Builder
3. On the bottom half of the Expression Builder window on the left side,
double click on Functions. Then click on Built-In Functions. This will bring
up a list of Categories in the center section and function names in the right
most section.
4. Click on the center section and select either Math or All. Then in the
right most section scroll down until the Round function appears.
5. Either click on the Paste button or double click on Round to add it to
the expression box in the top third of the builder.
6. Click on the <<number>> argument in the expression in the top pane of the
Expression Builder
7. The number to be used is the SumofOwed field in the FinesbyType query.
Select this object by first clicking on the bottom left most pane and double
clicking on Queries.
8. Still using the bottom left task pane, scroll down and select (single
click) on the FinesbyType query.
9. This will bring up the field names currently saved in the query. Select
SumofOwed from the center section by double clicking or clicking on Paste.
10. Click on the <<precision>> argument in the expression in the top pane
and substitue with a 0.
11. Click the OK button to close the Expression builder.
Click to expand...
Click to expand...
Click to expand...
 
V

Vicki0323

I understand that but what I dont understand is why the exclamation mark.

KARL DEWEY said:
It is a separated in a SQL statement between table and field or query name
and field.
--
KARL DEWEY
Build a little - Test a little


Vicki0323 said:
Actually it is on an exam I made and I dont understand the answer given on
the software. I dont understand the "!" I have never seen that before. (I
teach Microsoft Office...beginning)

KARL DEWEY said:
This sounds like a homework question.
--
KARL DEWEY
Build a little - Test a little


:

I have an access question. On a test I am giving this is the question:
What I don’t understand is the ! between the
Round([FinesbyType]![SumOfOwed],0) What does the ! mean? Thanks,

Vicki
THIS IS THE QUESTION: 26. A new query has been partially written based on a
previously written query, FinesbyType. This new query will take this
information and round the fines owed to the nearest dollar. Complete writing
this query using the Expression Builder tool and Access' built-in functions.
THIS IS THE ANSWER• Using the Menu
1. Click on the Field row in the next available blank column on the QBE grid
2. Launch the Expression Builder: (1) Click on the Access toolbar Expression
Builder button (2) Right click from the Field row of empty column and select
Expression Builder
3. In the top pane type in the formula: Round([FinesbyType]![SumOfOwed],0)
4. Click the Ok button
OR DO IT THIS WAY:

Using the Menu (2)
1. Click on the Field row in the next available blank column on the QBE grid
2. Launch the Expression Builder: (1) Click on the Access toolbar Expression
Builder button (2) Right click from the Field row of empty column and select
Expression Builder
3. On the bottom half of the Expression Builder window on the left side,
double click on Functions. Then click on Built-In Functions. This will bring
up a list of Categories in the center section and function names in the right
most section.
4. Click on the center section and select either Math or All. Then in the
right most section scroll down until the Round function appears.
5. Either click on the Paste button or double click on Round to add it to
the expression box in the top third of the builder.
6. Click on the <<number>> argument in the expression in the top pane of the
Expression Builder
7. The number to be used is the SumofOwed field in the FinesbyType query.
Select this object by first clicking on the bottom left most pane and double
clicking on Queries.
8. Still using the bottom left task pane, scroll down and select (single
click) on the FinesbyType query.
9. This will bring up the field names currently saved in the query. Select
SumofOwed from the center section by double clicking or clicking on Paste.
10. Click on the <<precision>> argument in the expression in the top pane
and substitue with a 0.
11. Click the OK button to close the Expression builder.
Click to expand...
Click to expand...
Click to expand...
 
K

KARL DEWEY

Why the semicolon at the end of a SQL statement? That is the language rules
that has been established for SQL
--
KARL DEWEY
Build a little - Test a little


Vicki0323 said:
I understand that but what I dont understand is why the exclamation mark.

KARL DEWEY said:
It is a separated in a SQL statement between table and field or query name
and field.
--
KARL DEWEY
Build a little - Test a little


Vicki0323 said:
Actually it is on an exam I made and I dont understand the answer given on
the software. I dont understand the "!" I have never seen that before. (I
teach Microsoft Office...beginning)

:

This sounds like a homework question.
--
KARL DEWEY
Build a little - Test a little


:

I have an access question. On a test I am giving this is the question:
What I don’t understand is the ! between the
Round([FinesbyType]![SumOfOwed],0) What does the ! mean? Thanks,

Vicki
THIS IS THE QUESTION: 26. A new query has been partially written based on a
previously written query, FinesbyType. This new query will take this
information and round the fines owed to the nearest dollar. Complete writing
this query using the Expression Builder tool and Access' built-in functions.
THIS IS THE ANSWER• Using the Menu
1. Click on the Field row in the next available blank column on the QBE grid
2. Launch the Expression Builder: (1) Click on the Access toolbar Expression
Builder button (2) Right click from the Field row of empty column and select
Expression Builder
3. In the top pane type in the formula: Round([FinesbyType]![SumOfOwed],0)
4. Click the Ok button
OR DO IT THIS WAY:

Using the Menu (2)
1. Click on the Field row in the next available blank column on the QBE grid
2. Launch the Expression Builder: (1) Click on the Access toolbar Expression
Builder button (2) Right click from the Field row of empty column and select
Expression Builder
3. On the bottom half of the Expression Builder window on the left side,
double click on Functions. Then click on Built-In Functions. This will bring
up a list of Categories in the center section and function names in the right
most section.
4. Click on the center section and select either Math or All. Then in the
right most section scroll down until the Round function appears.
5. Either click on the Paste button or double click on Round to add it to
the expression box in the top third of the builder.
6. Click on the <<number>> argument in the expression in the top pane of the
Expression Builder
7. The number to be used is the SumofOwed field in the FinesbyType query.
Select this object by first clicking on the bottom left most pane and double
clicking on Queries.
8. Still using the bottom left task pane, scroll down and select (single
click) on the FinesbyType query.
9. This will bring up the field names currently saved in the query. Select
SumofOwed from the center section by double clicking or clicking on Paste.
10. Click on the <<precision>> argument in the expression in the top pane
and substitue with a 0.
11. Click the OK button to close the Expression builder.
Click to expand...
Click to expand...
Click to expand...
 
V

Vicki0323

Round([FinesbyType]![SumOfOwed],0) No, why the exclamation mark between
them??????

KARL DEWEY said:
Why the semicolon at the end of a SQL statement? That is the language rules
that has been established for SQL
--
KARL DEWEY
Build a little - Test a little


Vicki0323 said:
I understand that but what I dont understand is why the exclamation mark.

KARL DEWEY said:
It is a separated in a SQL statement between table and field or query name
and field.
--
KARL DEWEY
Build a little - Test a little


:

Actually it is on an exam I made and I dont understand the answer given on
the software. I dont understand the "!" I have never seen that before. (I
teach Microsoft Office...beginning)

:

This sounds like a homework question.
--
KARL DEWEY
Build a little - Test a little


:

I have an access question. On a test I am giving this is the question:
What I don’t understand is the ! between the
Round([FinesbyType]![SumOfOwed],0) What does the ! mean? Thanks,

Vicki
THIS IS THE QUESTION: 26. A new query has been partially written based on a
previously written query, FinesbyType. This new query will take this
information and round the fines owed to the nearest dollar. Complete writing
this query using the Expression Builder tool and Access' built-in functions.
THIS IS THE ANSWER• Using the Menu
1. Click on the Field row in the next available blank column on the QBE grid
2. Launch the Expression Builder: (1) Click on the Access toolbar Expression
Builder button (2) Right click from the Field row of empty column and select
Expression Builder
3. In the top pane type in the formula: Round([FinesbyType]![SumOfOwed],0)
4. Click the Ok button
OR DO IT THIS WAY:

Using the Menu (2)
1. Click on the Field row in the next available blank column on the QBE grid
2. Launch the Expression Builder: (1) Click on the Access toolbar Expression
Builder button (2) Right click from the Field row of empty column and select
Expression Builder
3. On the bottom half of the Expression Builder window on the left side,
double click on Functions. Then click on Built-In Functions. This will bring
up a list of Categories in the center section and function names in the right
most section.
4. Click on the center section and select either Math or All. Then in the
right most section scroll down until the Round function appears.
5. Either click on the Paste button or double click on Round to add it to
the expression box in the top third of the builder.
6. Click on the <<number>> argument in the expression in the top pane of the
Expression Builder
7. The number to be used is the SumofOwed field in the FinesbyType query.
Select this object by first clicking on the bottom left most pane and double
clicking on Queries.
8. Still using the bottom left task pane, scroll down and select (single
click) on the FinesbyType query.
9. This will bring up the field names currently saved in the query. Select
SumofOwed from the center section by double clicking or clicking on Paste.
10. Click on the <<precision>> argument in the expression in the top pane
and substitue with a 0.
11. Click the OK button to close the Expression builder.
Click to expand...
Click to expand...
Click to expand...
 
K

KARL DEWEY

As I said before it is a separator in a SQL statement between table and field
or query name and field.
 
V

Vicki0323

Thanks. I have just never seen and exclamation point used and couldnt find a
reference to using it anywhere.
Vicki
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hyperlink fails to open on the first click 0
Help with Rate() function in expression builder 0
Expression Builder: Limit on Expressions? 1
Help with Rate() function in expression builder 4
Expression Builder 6
Publisher 2019 Format Picture window size too large to display OK button 0
Rounding expression in a query 1
How to Change criteria on a saved query using VBA 0

Top