Search results

There are only two images and I want them to be part of the database.

Never heard of partition query before. I'll check it. Thanks for suggestion.

Hello, I need Insert Logo on all reports. Logo is saved as Attachment in a table. How can I Insert this Logo in my reports. I tried using dlookup in control source of an image field but it didn't work. Best Regards Abdullah

Thanks it worked. I used incorrectly before. Thanks for the assistance.

Same results again. 39.6 is calculated as 40.

Thanks @arnelgp for reply. I tried second code but it stored lngPercentage as 0.4 (instead of 0.396) for input marks 39.6 out of 100. I prefer to use vba instead of query or dlookup as I have written the whole procedure and have to rewrite again to change for min max values. Is it not possible...

Hello, I'm trying to use following code to calculate percentage and then calculated percentage will be compared with a grading criteria to determine grades of students. Dim lngPercentage As Single lngPercentage = (cMarksObtaind * 100) / cMaximumMarks Problem is, if a percentage is 39.5, it is...

Thanks for reply @arnelgp, can you please tell which part of the code do I have to change and change to what value. Thanks again. Best Regards

Hello, I want to use the following code taken from this website (which is for SQL Server) for my access database which have access backend. How can I do so? What change do I have to make in the code. The code is to save an image file as BLOB and then retrieve the image from BLOB. Code is as...

Hi @theDBguy, Thanks for reply. Yeah sure, please see the attached file. In the cross tab query, you can see ClassID is set to 5 (class which contain 8 subjects) and you can switch it to ClassID = 3 for the class which contain 6 subject. rptClassResult is the report which I want to create for...

Hi all, I want to create subject wise result of full class of student so that first 2 columns contain names of student, next 6 or 8 (no may change with class) columns contain subject names in header and obtained marks by each student in detail section, then next 3 columns for total marks...

Thank you very much @Gasman, it worked perfectly. First I thought, writing sum in the query was a typo which it wasn't. Using sum to get no of counts was very smart. Bundler of thanks.

Thanks for reply. Please find attached db. Query1 is not showing corresponding results for users e.g. right now I have selected user 2. This query will serve as source object for the subform. I try to use this code but it is giving syntax error and is not letting me save or view the query in...

Hello, I want to use a subform with master and child link as StudentID and the purpose is to get student attendance status in each month. I'm using following query but it is not working as required. I don't know where is wrong. Can anybody guide me how can I get Attendance status of a student...

Thanks @Pat Hartman for the code. I'll try to implement it into my forms as I'm using month year approach in 4-5 forms.

Thanks for reply. If I store as date then will I be able to set so that user have to select month and year only from two combo or one combo (for date) and one textbox for year. If yes then any suggestion how?

I did tried this but it didn't work either (as @isladogs confirmed). There may be other methods which might be faster and easier but I am not good at queries so until I find good alternate to this method, I am using subquery to do the job. Thanks for efforts to help me in this regard.

Dear @isladogs, the query is not working, it do not insert any record for new month since TeacherID is already present in the tblSalary for previous months (is Null can't be true, I guess). I even checked by removing is Null from teacherID criteria but it didn't work either (so my guess is wrong).

Thanks @Pat Hartman for suggestion. I agree with you about the date field but my user want like this separately for months and years.

Thanks a lot @isladogs. Right now I'm away from PC. I'll check and then update here.