queries

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

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

Queries

resolvedResolved · Low Priority · Version 2003

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?

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 tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips


Server loaded in 0.08 secs.