expression builder

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Access Training and help » Expression Builder

Expression Builder

resolvedResolved · Low Priority · Version 2003

Theo has attended:
Access Intermediate course

Expression Builder

What is Express Builder?

RE: Expression Builder

Dear Theo

Thank you for attending Access Intermediate !! I hope you enjoyed the course and benefited from it.


If you have difficulty remembering the names of the fields, tables or functions when you perfom calculation in a table, Query or Forms then you can use Expression builder to assist you.

You can use the Expression Builder to create a new expression, or you can select from pre-built expressions, including expressions for displaying page numbers, the current date, and the current date and time.


I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007

Fri 26 Dec 2008: Automatically marked as resolved.


 

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


Server loaded in 0.08 secs.