Search results

Hi all I am working on a project in which i have created a data entry form. This form has various options to be selected and a button against each option to add comments. When this button is clicked, it calls for another form with a textbox to enter comments. My problem is that I am not...

It worked... Thanks a ton

Thank you for the solution. However, how will I call this function in report?

Hi all I am trying to use IF/ELSE statement in one of the reports I am building, however, not able to do it. Basically, I want the statement to look at the Average of Score and then return a value accordingly. The breakdown is below : Score is 30 - Platinum Is between 25 & 29 - Gold Is...

Hi all I require help with something. In my company we write letters to the clients in response to their queries, however, there are certain guidelines to be followed like salutation should come in one line subject in specific line and so on. This causes a lot of problem. I am thinking of...

Thanks for this... it was really helpful. However, could you please tell me if i want add this data to a table, how that can be done?

Hi all I have a form which has 3 comboboxes. What i am looking to do is to filter the combobox based on other. That is, when the user select an option from first combobox, the options in below combobox filters and accordingly and when an option is selected in second combobox, the options in...

Thanks Mresann... ur solution helped me a lot. was looking for this from past one week.

Thanks... but i want only the updated records. With this query i am still getting all records.

Hi I have a table in which one record gets updated multiple times. I want to run a query that gives me the latest update. Thanks in advance

I have grouped them correctly, Date field has Max and rest of the fields Group By

Yes i did, but that is giving me the entire list

Yes i have only one table. However, will this give me dupliucate records?

Yes i have a date field and also an ID field as date can be same

Hi James Yes i am looking to keep the latest status of all duplicate records and delete rest of them.

Hi I am a beginner in access. My problem is that i have created a database, which has a list of customers with their unique ID's. Also, have many duplicate records. Table also has a Status field which can be Email sent, Chaser Sent and Amount Received. I need to find out and delete the...