Recent content by balaryan

Thanks Gasman. Your information saved me in right time. it works. :) Thanks a ton my friend. :D:o

Hi All, Good day. I am using MS Access 2007 and have a report which display the list of values (say 10 fields) from the basic SELECT * FROM table query. I need to dynamically set the BOLD based on the particular value for the fifth field which was assigned from Query. if it doesn't match it...

Hi Plog, I need your help for the requirement listed below. SELECT CessioneCredito.Importo, CessioneCredito.Anno, CessioneCredito.Data_Movimento, CessioneCredito.Note_Liq_Cessione_Credito FROM CessioneCredito WHERE (((CessioneCredito.ID_Agente)=[Reports]![R_StoricoCessCredAg]![ID_Agente]))...

Hi Namliam, I need a report with four columns as per the attachment, like Data_Movimento Anno Sum Total as shown in the attachment. But the total should be displayed to minimum of Data_movimento field for every year. So any idea how to achieve it in SQL query?

Hi All, Good day. I am new born to VBA and tried writing a SQL query to produce the list of details in year wise DESCENDING order for the input - Agent ID. In addition to that I need to get the sum of amount fields year wise in the report. How to achieve it???. Please find the attached report...

Hi Plog, Just to reiterate on my statement that i wrote two queries which listed below Query 1: This query generate the list of records with fields Anno (year), Data_Movimento (Date), Note description and Agent description in descending order. SELECT CessioneCredito.Importo...

Hi Plog, That also will help in my case. I can create a object query and include that name in the recordsource of the REPORT. But my doubt is how to achieve it in object query as i am aware it hold only one single query which should select the required fields and do the validation, sum the...

Attached the screenshot of report for reference

Hi All, I am new to this forum and new to VBA n SQL skill set. Need your advice and direct me to the right path if i am wrong. As a part of my case study, I got a scenario to produce the Report with corresponding information attached in the screenshot (kindly check the format). I need to...

Plog, As I am new to this forum as well to VBA / SQL query skills, no idea on that. We write the SQL queries and design the report using VBA only. We use MS-ACCESS tables as database to fetch data. Ultimately, Output of the query should be thrown or mapped to the report. For your response...

Hi Plog, Thanks for your quick response and apologies for not providing sufficient information before. In my case, i will be using two tables to get the required output fields. So Cessionecredito is Table one and Agenzia is Table two. I agree with you on referring the field names. :) Also...

Hi All, I am new to this forum and new to VBA n SQL skill set. Need your advice and direct me to the right path if i am wrong. As a part of my case study, I got a scenario to produce the Employee report for the list of years. It has following fields named Year, Name, Designation, DOJ, Salary...