Recent content by Nitesh9999

Thanks pat that is brilliant!!

Ah, i spotted an error, and changed a field type. But this is it now, i hope. Suggestions/Views welcome... Thanks Nitesh

Please let it be right, PLEASE!!!! Here it is If this aint right I have no idea what to do... Data redundancy - i cant see any. All other things please query me on. but make sure you ask in laymans terms. I think alot of the trouble i've had has been communicating my problem across to you...

Your right Pat GP is General Practitioner. Ive been on another forum (still trying there too) where the author of that book is an active, and he couldnt help me (yet). Ive read through tonnes of material on Normalization, different theories, but im still lost. If you look at "Copy of Working...

Hey Pat When you say Dates should be with treatment record, which table? tblTreatmentTypes, tblTreatmentGroups or tblPatients (Where i think it should go). And also isnt the GP data in a table of its own already? Sorry i'm still getting to grasps with this normalization game Thanks Nitesh

Ive taken your advice (seperated tblPatients). You mention trawling through data to find a particular GP. I know that it makes sense but we will never (well we never have *Yet*) query on the GPName field. So the oddspelling would'nt make a difference. But i've given it is own table (Dont think...

Thanks guys. This is what i want to end up with (attached). I built this to learn how to link combos etc. But obviously maintaining that monster would be a nightmare. The main table in the attached tblPatients is what i am splitting up. The report "all" is what i need to end up with (type in...

Hey Col Thanks for the reply Point 1 This one seems to be confusing me. The financial month doesn't really relate to the patient in any way. The financial month table will hold just 12 values. 1-12 for each fiscal month. With 1= april etc. Point 2 The Main table is tblPatients. the other...

Hey i have finally got around to create my actual db, putting into practice what i have learned in these forums over the last couple of weeks. This is a bit of background on why the db is needed... What im trying to do is convert our excel spreadsheets to a db. This has the benifits of giving...

Ok latest Question. Now that i have got Xtab parameters working, i was wondering if there is a parameter query that works in reverse. Where the value you enter in the paramater pop up means that paticular value dosnt show? EG Table Field 1 bob mark sam phil Query Field Field 1 Table Table...

Thanks again Pat. The row sum will be helpful, and I completely forgot about it ;) . And the Nz should help me adding the coloumns. The next thing i would like to ask is how to add a simple parameter query on the PCTCode Field in the query "qyCombineCrossTabs". I tried the usual "[]" but...

Hey one other thing, Ive put this query into a report... The only other thing i need now to finish this paticular report in the DB is to be able to sum the rows across and the columns down. But when i do this simple "Sum" i get blank boxes when i preview the report. Not even the usual "error"...

Thanks Pat. http://www.utteraccess.com/forums/showflat.php?Cat=&Number=670425&page=&view=&sb=5&o=&fpart=all&vc=1 Looks like the right thing to do. Attached is how "I" pulled it it off... Maybe it can help Someone else. Nitesh

Is it only possible to have one value "crosstab"? So the following crosstab query design is impossible? Field..........Field A..........Field B............Field C.............Field D........Field E Table all fro the same table Total.......Group By........Group By.........Group...

Thanks for that guys. Sorry if i wasn't clear but i managed to solve the problem. PS i know about the one to many relationship. It was just that i was trying to put my query accross in an understandable manner. Thanks again Nitesh