Recent content by chrisjnelson

Thanks Graham:)

Is there a way of designing your forms so that they are different shapes? rather than dull rectangles

I have a simple query that works out a a date 1 day before a babies first birthday. B_E_D: [Children]![Date of Birth]+364.3333 What i want to do is get the query to return the B_E_D in a date format rather than a number. Can you help?? Thanks in advance

Thanks for the tip, but i didnt explain myself properly. Sorry!! I need he data on a form so that i can use it as a type of register. (i.e names down the left, start time in the centre and finish time down the right side)

This should be so easy but for some reason it will not work!!! I want a very simple macro that works of a command button, the macro needs to do the following: Save form Ask user if they wish to quit database, return to switchboard or remain in the form. Why will it not work?

I have a query that works out peoples ages and wether they are current, i have another query that pigeon holes those ages into age ranges. What i want it to do next is use this data on a form in a list format. I.e i want the form to return a list of current people broken down into their age...

Alex, your a star, cheers mate !!!

Alex, Thanx for your reply. My structure is as follows, i have three tables. ( [Children] / [Date] / [Customers] ) The [Customers] table is not really relevant for this query as it contains info on the parents. I have the beginnings of a form called [attendance] that has a field called...

I need to create a query that works out only current children attending a nuresry. The children need to be split into seperate age ranges. (0-1) (1-4) (4-5). I have already established the dates that the children progress within the nursery but cannot seem to run a succesful query that...