Search results

Hopefully this makes sense The name of the report. Analysis The name of the query that the report is based on. the report is made up of 5 subreports, so the basic report is baisically built around my staff table, with another table directorates there to help me filter. The sub reprts are...

Hi all Is there a way of doing this. I have a report which contains a page for each member of staff.I currently can view individual pages using a form which filters the report. I am using 2007 so i can easily output the whole report to Pdf, what i need to do is output each indivual staff...

I have a chart in one of my reports, it is a stacked bar chart. The labels are on the chart rather than in a legend. The problem is that the chart still shows the label even if its value is zero Can i hide the labels of zero valued catergorys for each report.

No I dont think thats what i am after, I have a field in the main form which is calculated from data in the main form and a list box in the main form which sums a column in the sub form through a query. I dont want the user to be able to close the form unless these two values are the same...

I have a form with a subform. On the main form i have a list box which sums a column in the subform through a query. I want to ensure that this field equals another field in the main form but cant get it to work. I know this is because of the query which is calculating the sum but i dont know...

I think i have it working now, the query test does what i want it to. However when i run the report wizard on the query it crashes, i can design the report from scratch so its not a problem but i was wondering if it points to errors in my query design or table design. I have attached my...

sorry i missed a table out on that diagram. The table(called instances)links programmes to modules via the progID and Mod ID. The table contains these two fields and a primary key of InsID. Cheers

I have attached the structure of my tables, relationships and attempted query. Many Thanks Geoff

well I cant get it straight in my head how it would work. My staff table with my primary key feeds into the three table where the foreign keys are for module leader, module lecturer and programme leader. I want to be able to run a query where it will return information about the module...

I have a staff table which consists of an ID key, First Name, and Surname, this then feeds into three tables Modules, Modulelecturers, programmes connected by the ID KEY. This works fine unless i am doing a query bassed on two of these tables. Do i have this set up wrong?? or is there...

try again, hopefully this will work

sorry forgot the file hopefully this will work

Ok i have had to deletemost of it as it wouldnt let me upload it. If you go into form Module CRS select mel walker in first combo box then gender and health in second combo box In the CRN it now shows 15316, however if you look in the table instances there is also a crn 15312 also...

i have a combo box with titles in, when i select a title, information is shown about it. One of these filelds (CRN) could have more than one instance connected to the title. At the moment when i select the title it only shows one of these CRN, is there a way to show all of the CRN's

I have a form with a combo box. When you select an item out of the combo box it automatically shows you information about that record. The field in the the combo box is called completemodnumber and is a primary key in a number of my tables. in on of the tables in which completemodnumber is not...

Thanks for your quick reply, Yes i have worked it out now that is great. Thanks very much Geoff

I want a form with a subform linked by a field called CompleteCrsCode. However I want to use the subform for data-entry. So when the user is imputting the records in the subform i want the CompleteCrsCode-child field to be automatically filled in depeding on what is in the master field in the...