Create Queries with Reports

A

AL

Hello to all in group,

I'm trying to build a query that will show the first three characters
of a field. Not sure of the correct experssions to use.

I'm also trying to have a report count the total number of records and
have that total placed in the report footer. I know that I have to add
a text box to the report but not sure of the SQL statement to use.
Thank you in advance.
 
R

Rick Brandt

AL said:
Hello to all in group,

I'm trying to build a query that will show the first three characters
of a field. Not sure of the correct experssions to use.
Click to expand...

NewField: Left([FieldName], 3)

I'm also trying to have a report count the total number of records and
have that total placed in the report footer. I know that I have to add
a text box to the report but not sure of the SQL statement to use.
Click to expand...

In a TextBox (in the ReportFooter) enter a ControlSource of...

=Count(*)
 
A

AL

Rick,

Thanks for the help. When I create a report from the query "NewField:
Left([FieldName], 3)" using the report wizard in Access. The report
shows the field name but no data in actual records show. What could I
be doing wrong when creating a report from the query. The query runs
fine and it shows the data with no problems.
 
Top