Year 12s: what will be the first way you research your future options? >>

GCSE ICT Help

I'm doing a database coursework and I think I need to create an 'If' function or possibility for the following situation:

A company has two memberships, Standard and Gold. Only Gold has an expiry date. A membership expiry will have to be filled in if the word 'Gold' is entered into the 'membership type' cell. How can I use validation and/or input masks to create a message saying:

'You have not entered a expiry date for the Gold membership'

while not showing the message when 'standard membership' is selected. I am using Access and a list box for the situation.

I presume it is something along the lines of:
IFF (tablefield="Gold", Required=Yes, Required=No)

Reply 1

j00ni

It's been years since I used Access, but I suppose you could use SQL, something along the lines of:

SELECT MemberDatabase.MemberID, MemberDatabase.ExpiryDate
FROM MemberDatabase
WHERE MemberDatabase.MembershipType="Gold"
AND MemberDatabase.ExpiryDate=NULL

Which will display a list of all Gold members without expiry dates assigned (NB you will have to substitute the names of fields/database tables for those which you used)

Latest

Articles for you

Edexcel A-Level Economics Paper 1 - Unofficial Mark Scheme - 18 May 2023

How to revise for GCSE Design Technology exams: AQA explains what to do

Artificial intelligence and robotics degree personal statement example (1a) with review and advice

How to write an excellent personal statement in 10 steps

GCSE ICT Help

Related discussions

Latest

Trending

Trending

Articles for you