Criteria???

  • Thread starter Thread starter Brenda
  • Start date Start date
B

Brenda

I'm creating a report that will query a recordset. One of my fields contains
a mixture of alpha, num, and a %. I'd like my report to omit the %. How might
I accomplish this??
 
do you mean the % sign? Or the entire number all together?

If you go to the design view of the report you can change number formats
just like on a form.
 
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

Growable Text Box in Report 2
VBA: How can I use a string variable as autofilter criteria? 4
Setting criteria in query 2
field Null but not Null 9
Getting Around VBA Not Resolving Query Refs To Forms? 8
Running reports in a multiuser VB/Access environment 0
Append Query - no records with #Num! 6
Report expression 8

Back
Top