Search options (Page 3 of 6)

Hello,
If I delete the calculated field for doctor's fees the programme runs, but the sum function in cf_totalcharges does not work. How to do this correctly?

Hello Ehwagner and Sibprogsistem
Thanks for endorsing the method. The data are correctly displayed in the table grid.
The project is about creating a Mutual Fund Database. One table_1 (AA_011_MF_SWITCH) stores mutual fund switches between Source_Fund and Destination_Fund. This data is collected by form AA_Form_011_MF_SWITCHES_RECORD, which contains two combo boxes for Source_Fund and Destination_Fund. The dropdown list in these fields refers to the foreign keys from the lookup table of mutual funds (LU_003_FUND_SELECT). I was in doubt about how to get the correct Source_Fund and Destination_Fund, from the lookup table, when a table grid auto query is set up to get all data from the  table_1. Finally creating calculated fields in table_1 for Source_Fund and Destination_Fund gets the correct data.

Hello Derek,
Thanks again. The SQL query is working perfectly. I have learnt how to add 1 day when there is a date/time format, to get the correct result. I have learnt from your different programs on how to get data from linked tables using a calculated field. I would love to learn how to use the same for this query. Please!
Regards,
Eyeman

Hello Derek,
I am fine. Hope you're fine too.
Once again you have provided me with the perfect solution and explained so clearly! Now I have learnt how to extract date from date/time and how to use the WHERE clause to get data for a date range. Thank you so much.
Regards,
Eyeman

Hello Derek,
Now I understand clearly, what the symbol signifies. Thank you once again, for helping me learn.
Regards,
Eyeman

Hello,
I  have almost generated the desired report using Report(Sql) option. I'm stuck at one point. I want to include the Select_Eye for the Complaints also. But since Select_Eye is a foreign key to both aa_004_clinics and aa_003_complaints, there appears an error message "ambiguous Select_Eye...".How can the eye of complaint and diagnosis be selected? Do I need separate lookup tables for Complaint_Eye and Diagnosis_Eye?
Regards,
Eyeman

Hello Derek,
Thanks for your insights. I have made the OPD_ID as the main link for the tables aa_03_complaints and_ aa_04_clinics. I might include diagnosis within the aa_03_complaints table, but I would like to include other details like History, Glass Power, Medications, Advice etc linked to each OPD_ID. In the original project, I have created sub-forms for each of this and stored them in separate tables. As you have mentioned, I would need a main report with related sub-reports. How to create the same?
Regards,
Eyeman

Hello Colin, Hello Derek,
Both methods give the desired result.  Learnt a lot. Thank you so much.
Regards,
Eyeman

Good afternoon Derek,
I now understand that the 'clear' button is simply another search. I have followed your example and made the necessary changes. The 'clear' button is now giving the desired search result. I'm so happy! Thank you so much for teaching me a new lesson.
Regards,
Eyeman

Hello Derek,
Thank you once again. I have followed your guidelines and everything working perfectly. The form looks beautiful now, with image loaded.
Regards,
Eyeman

Hello Derek,
I cannot thank you enough!  I have made the correction that you highlighted so precisely and the app is now working perfectly. I have also made a folder for all the photos in the programme folder itself and linked all photos.
Regards,
Eyeman