Conditional fields in access queries

The UK's most regular instructor-led training courses.
Training information: access+course+training · Microsoft.access.courses · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · High Priority · Version 2007

2 posts

ReplyWed 27 May 2009, 14:44Delegate Mark said...

Mark has attended:
Access Introduction course
Access Intermediate course
Access Advanced course

Conditional fields in access queries

Is it possible to make the fields that are displayed in an access query conditional to other fields or variable. e.g. if I have a table that has columns for Jan plan sales, feb plan sales,etc. but I want a query which will only return this months and next months' sales plan.

I know I could change the layout of the table so that each month generates a new row but the tables I have to use already exist in the above format.

Version	Date	Location	Places available	Book	Next place rate (£)
Access Advanced 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Fri 19 Mar 2010	Bloomsbury	4		£235	£240
2007	Wed 24 Mar 2010	Bloomsbury	5		£240	£245
2003	Tue 6 Apr 2010	Southwark	9		£203	£208
2007	Thu 13 May 2010	Bloomsbury	7		£188	£193
2003	Tue 18 May 2010	Bloomsbury	9		£182	£187
2003	Fri 2 Jul 2010	Bloomsbury	7		£85	£90
Full Schedule: See all 11 Access Advanced course dates. Bookings currently available until 14th December 2010.

870 posts

ReplyFri 29 May 2009, 11:05Trainer Rajeev said...

RE: conditional fields in access queries

Dear Mark

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

I would like to please further clarify your query!!

Are you saying that you want the query to display only the current month and next month without showing all the months from an existing table?

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
MCT

· Interested In The Golden Rules For Building Access Databases?
· Microsoft Access Tighten your Security Controls
· Be Top Of The Form With Access 2007
· Discover the Secrets within Your Business through Microsoft Access Training
· Want to Become the Office Hero? MS Project Training Could be the Answer

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

Access tip:

Pop up property

If you want to focus the attention of a form / switchboard to a user then you can change the propeties of a form/switchboard for Pop up to On.

This meand tht the focus for the user must be on the form / switchboard

View all Access hints and tips