[Year 12 IT Apps] formulas for Access 2010 queries

[Mark Scott]

Mike

Thanks, that's great but I was hoping someone might have a simpler version that would be less daunting for my students.

Mark Scott
Luther College
"We are what we pretend to be, so we must be careful what we pretend to be"

From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au] On Behalf Of Mike Brookes
Sent: Monday, 16 May 2011 1:56 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] formulas for Access 2010 queries

Hi Mark et Al

If you click on the help button at the top right of the screen, type "query criteria" in the search box, then select "Examples of search criteria" you will get a summary which includes a few tables showing functions which can be used in queries plus several examples of their use.

Mike Brookes
Semi retired gentleman
Copperfield College


On 16/05/2011 12:32 PM, Mark Scott wrote:
Hi all

I am hoping someone will have a summary of formulas for Access 2010 queries that they would be willing to share.

Mark Scott
Luther College
"We are what we pretend to be, so we must be careful what we pretend to be"






_______________________________________________

http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe

IT Applications Mailing List kindly supported by

http://www.vcaa.vic.edu.au/vce/studies/infotech/itapplications3-4.html - Victorian Curriculum and Assessment Authority and

http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20110516/165e252a/attachment.html