Two MS Access questions

[amir_9]

Hi guys, I am in need of a little bit of help with my MS access assignment. I appreciate your time and help



Here goes

I'm creating a Dating Database on MS access, Now I've been given the attributes for all the tables. They are five (Client, Hobby, Meeting, ClientHobby, ClientMeeting)

This is the first question

Now I'm needed to create a form which allows me to enter the client data + at least two interests and their age calculated from their DOB. Seeing as I was only asked to put DOB in the actual Client table, I thought I'd create an Age query and then make that form out of the Age Query. (I already successfully managed to get the Age out of DOB in that query in a field of its own)

However, how can I add the hobbies field to that age query so I can finally create the form that I am required to do?


--------

Second, I am to create a query which will be used for ‘matching’ clients. The criteria that you will use are: gender, age (using a range e.g. 20-25), interests/hobbies and city/town, this query ill be used to create a report which lists all the clients who match the entered criteria. How am I to do that?


Once again, thanks for your time.

[June7]

You don't need a query just for the age calculation. This calculation can be done in a textbox on a form or report.

I think you need to consider a form/subform arrangement.

Main form bound to Client table. Subform bound to ClientHobby table, another subform bound to ClientMeeting table.

Must input records into Hobby and Meeting tables before they will be available for selection in the ClientHobby or ClientMeeting subforms.

Access Help (or Google for tutorials, or textbook) has guidelines on building form/subform.

For your 'matching' report, review tutorials at http://datapigtechnologies.com/AccessMain.htm especially the one on Creating a Basic Search Form in the Access Forms: Tips & Techniques section. The parameterized query could be the RecordSource for a report. Again, refer to Access Help (or Google, or textbook) for guidelines on building report. The age range criteria will be the trickiest. If you have problems with that, when you get to that point, post question.

[amir_9]

Thanks for your response, I've managed to add ''Hobbies'' to the client form. I'm trying to get the textbox for that to grab the information from the ''Clienthobby'' section, but to no avail. Any help?

[June7]

I don't understand what you have done. Do you want to provide project for analysis?

[amir_9]

Thanks for your help, managed to get it all working.

Cheers!