Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Queries

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Queries

Resolved · Low Priority · Version 2003

Reply Tue 28 Oct 2008, 16:43Delegate Mark said...

Mark has attended:
Access Intermediate course
Excel VBA Intro Intermediate course

Queries

Can you use more advanced mathematical functions than sum, count etc. e.g. use of variables?

For upcoming training course dates see: Pricing & availability

Reply Tue 4 Nov 2008, 15:19Trainer Rajeev said...

RE: Queries

Dear Mark

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

In queries you can use the Expression Builder and as long as you are familiar with the function/s you can use the Functions catergory and choose from various sub categories Built In Function such as financial, Mathematical, Text, etc...

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

Access articles

· Tips for designing databases in Microsoft Access
· Protect Sensitive Access Databases With A Password
· 3 Reasons to Switch from Excel to MS Access - You'll be Glad You Did!
· Reasons to Consider Microsoft Access Training
· Why a Microsoft Access Course Could Change the Way You Do Business

Please browse our web site to find out more about
microsoft.access.courses and other Microsoft training courses.

Access tip:

Choosing data types in Access

Not sure which data type to use for your Access fields? Here are some guidelines to help you choose a data type to assign to a field.

- The Text data type can accept up to 255 characters. For information that will be recorded in paragraphs, use Memo.

- Also use Text for numbers that aren't going to be used in calculations, e.g. phone numbers.

- Use the Currency data type for monetary amounts.

- Use Date/Time for dates.

- Most other numbers can use the Number data type, but the Field Size property may have to be altered.

- For fields that have only two alternatives (yes, no) use Yes/No data type. If there is likely to be a third entry option (e.g. maybe or don't know) use Text instead.

View all Access hints and tips