Search results

I would set my tables up this way: BikeID Bike_Name Bike_Description Bike_etc BikeHireID CustomerID BikeID Other_BikeHire_info I would then hook them together as Bike info as main form with BikeHire as a subform with the BikeID as the connection. You could do the same for the customers. Sam

Try cutting out unnecessary data and posting your db and see if others can give it a look to see the problem.

Upload the db and others may be able to see what is happening. (If you do then cut out most of the records to save space) Sam

Might be best if you upload the db (or a version with only a little data). Others may be then able to see what you are on about. Sam

Look at the type of relationships you have created. You can choose from 3 main types. Depending on the type you get different results.

I believe you have posted the SQL of a query. I am not that good at SQL but within the query itself I would type this under the criteria for the date field. Between [Type the beginning date:] And [Type the ending date:] This will promt you for the required date parameters

Donna, What you ask is quite complex. It would take an experienced programmer a while to sort things out even if he/she had access to you database. (no pun intended) Sam

What do you mean by 'Directive'?.. I know of the If...Else statement

Ok, I did up a dummy db. As you can see from the query you are now able to select from 'Families'. You could tie the query into a drop box on a form or create a subform that used the FamilyID as a join. Let me know if this works for you. Sam

Are you using Access 2000?.. If so I will do up a dummy db and show you how I would handle this. (That is if I can get it to work!) Sam

I believe you will need to structure your tables differently. You would create an Attendance table with StudentID, Date, StatusTypeID. The same would apply for Grades. Grade Table would have StudentID, Year and Grade. Sam

What datapart?... Do you want the '05' of '2005'?

I believe you can have as many rows you need grouped as 'row headings'. There is no limit as far as I know.

Look at the 'Quarterly Orders by Product' in the North Wind sample. This is the elegant way to do this. Base your report on a query built along the same lines. Sam

List Box Change the list box property 'MultiSelect' from 'none' to 'extended'. This should solve your problem. Sam

Niels, I believe you would need tables for all the variables. (i.e. target groups, subjects, countries, etc). You would then pull them together in a table called Projects with 'foreign keys'. All the variables could be inputted with sub forms tied to the various tables within the main form...

secondary ID's Groengoen, Am I right in assuming that you have Insurance record with 2 ID's pointing to a people file? Or is there 2 separate policies for the husband wife example? Sam