access 2003 training course london - criteria reports
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » access 2003 training course london - Criteria for reports

access 2003 training course london - Criteria for reports

resolvedResolved · Low Priority · Version Standard

replyReply Mon 6 Aug 2007, 10:42Delegate Rachael said...

Rachael has attended:
Access Introduction course

Criteria for reports

Can I use text as a filter in reports as well as numbers?

For upcoming training course dates see: Pricing & availability

replyReply Tue 7 Aug 2007, 10:23Trainer Richard said...

RE: Criteria for reports

Hi Rachael

Yes, you can use text as a filter.
If you give me an example of what you want to achieve, then I can be more specific.

Regards

Richard

 

Access tip:

Dsum

You can create percentage values based on individual products / items by using a Dsum function (used with a grouped query)

[Each value column] / Dsum[field:total for the column needed to be calculated],[tablename]

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard