Search results

I am having difficulty applying this instruction; I therefore have attached my actual query so you can show me how to append your suggestion. Please bear in mind that all the field name I gave before were fictitious to keep my question simple. The following however is actual: SELECT [last...

Do I write the Having Clause in the query or in the report?

Where can I find example of Having Clause on the internet?

Good Morning All, I have a report with lists of students and their scores. Each student does 8 different subjects. My report has a calculated field which tallies the number of subjects each student passes. So the report shows 2 things - Student name and number of subjects passed. I however...

Yes you are correct; the field type is lookup. But what does that mean? Does it mean that the string values cannot appear? or is there another way? I do need to have the lookup field type.

2 things are happening here which I would be happy to have explained. 1. In the design view I drag and drop the field “Division1” from the field list unto the report form. This show the expected results for example “Agriculture” i.e the list of text items in this field using the table as...

Good Night everyone. I selected and dragged a field "Diivision1" to my report then I appended the word "Division". in the view mode nothing appears. Alternative I used the Expression builder and enter the following: =[Division1] & " " & "Division" but nothing appear in the view. Can...

Thanks. Every thing works fine.

Thanks. I entered the following: Division & " " & #"Division" I got the following message: the expression you entered has an invalid date value. Division is not a number value it is a string. The results I am expecting is by example as follows: Science Division

Good Night, I would like to append a text item to each value in a calculated field. consider the field name is "Division" and I want to append the word "Division" to the values put out by the field "Division" My attempt was: Division & " " & "Division". This produced an error in the...

Thanks. Problem solved.

Good Night all, I am seeking some assistance in generating a common Heather for each page in a report. Is this possible? Thanks in advance

Good night, I have a field in my query which returns results based on a formula that is a function of other fields. The results are: Pass and Fail. I want to make a query that returns only Fail rows. When I enter Fail as the criteria, a parameter box pops up requesting information be entered...

Thanks. I now understand.

Thanks I would rephrase my question. How can the average of the values in a single field be assertained in a report when that field is the result of calculations of other fields? George

Thanks. But I want an average of the items in the text29 field items. I.e. I want to add all the items in one field and divide by the number of items in the field.

Good morning. In a report there is an unbounded field (Text29) that obtains its data by adding 2 fields [CourseMark] and [ExamMark]. An unbounded field (Text58) is added to the header to receive/calculate the average of the Text29 field. The code entered to get the average is: Ave ([Text29])...

Thanks but it give the same problem. Maybe my problem is with Outlook. I wonder if I have to set it up or just use it as it is. Can't Yahoo be used instead of Outlook? Maybe nothing is wrong with the statement. Where can I find information on setting up Outlook?

What i am not following yet is how do I connect the code to the field

I think my problem needs restating so here it is: There is a table with 2 fields: Name and scores. There is a query based on this table, and it has an additional field called comments. All this comments field is required to do is to state: if the score is "" then the score is "Absent"