Create Queries with Reports

  • Thread starter Thread starter AL
  • Start date Start date
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.
 
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(*)
 
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.
 
You must log in or register to reply here.

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

Totaling An Aggregate Expression On A Report 4
Decimal places in report 2
Can't create a report from my query in Access 1
Need Help to Count in Footer, then Sum in 2nd Footer then Sum agai 1
Need some help with reporting 0
Use a report to count the # records >0 in Access 2003 2
SQL Query Too Complex 2
A03 - count in report footer gives me #Error? 0

Back
Top