Recent content by ritchie_h

Hi I am a teacher trying to develop a access database programme to create lesson plans record and forecast etc...for myself and department. I think some of it a bit over my head but i am trying my best but this part got me stuck any help would be much appreciated. I have a form...

I got through by using cross tab to get the information in the order to plot it....my problem was the master and child links to get the data to be dynamic...but i think it got through....it working so far still testing. thanks for the help.

ok i used your first suggestion and added the two fields ear and score...but now i am having the problem of mapping my data for the chart as i will need to get the following information to plot Frequency Against series one Right Ear Score and seires 2 Left Ear Score but i am trying a few...

thanks for the information...but is there any other way to go about it using union queries and then cross tab for instance

Hi I have search very hard and tried almost every transpose sql queries but i not getting it so i am asking for some help here. This is my Table AdioDTlID MMID DOAudioData Frequency RightEar LeftEar 1 20 04-Apr-10 0.50 10...

Even though harsh....with a after thought a very sensible idea...Thats eaxtly what i would doo...thanks a million and great effort on your part....

Thats cool good work, I might end up using this method thanks for the hard work. You said their are other methods, you mind elaborating a bit i will do the research and see if it is more profitable

Any body think they can help me with this problem, or offer a differend direction would be greatful....

if you know how via vb lay it on me

so any suggestions on how to open the patient details main form from the patient list main ensuring you goto specified patient

I will hide the comid's after i just using it for development purposes

I just keep it in their so that i can ensure the relationships are present and not lost during development

Yes that is what i will do

if i used the open args how am i getting open form patients Details main from the patients list main to open for the specified patient and also open the same said form as a new form. I am not that great at access programming

No I don;t need to hold the history under the old company and yes it will transfer all the old records to the new company