Search results

Hi Everyone, Thanks for looking at my problem and offering your valuable suggestions. My issue is RESOLVED by preparing a Form with [centre] Field. Macro works perfectly. Many Thanks & Regards, Kamal Doctor

Macro is being run from Access Switchboard Manager. There are 9 different Horse Racing Centres in India. I want to run 1 set of Queries when [centre] is "DEL" or "OOT". For rest of the [centre]s I want to run Else set of queries. The entire Macro will be pertaining to only 1 centre at a time.

This is from a Table having Field Name as centre which is a Text field

Tried still gives me Error

Hi, I am trying to write If condition in a Macro to execute query. Following condition gives me Error 2766 [MaxHorseRatingTable]![centre]=DEL centre is a TEXT field Please Guide. Thanks & Regards Kamal Doctor

Hi Plog, The SQL you wrote for me worked brilliantly for me so far. I have recently introduced a text field called 'Season' for sorting my data. As the HName as well as RefNo may repeat in different 'Season', I request your help in incorporating 'Season' as additional criteia in the SQL...

hi plog, It worked.....exactly the way I wanted it !!! Please ignore my earlier post. Thanks A Ton.....This opens up a big knowledge bank for me which will provide me with many opportunities to manipulate data. thanks & regards

hi plog, OK. I went into SQL View and pasted the statement provided by you and tried to run the query which is giving me "Compile Error Message".

hi plog, Thanks. I am a novice and never worked with SQL statements. Where do I write this statement? In the meantime I will try and gather more knowledge about SQL. Thanks & Regards

Hi plog, Thanks for your response. Yes indeed DistTotal is calculated value which will not change once calculated and posted. Default value is 0(zero). Yes, I will change Length and DistTotal field types to numeric. ORIGINAL DATA: --------------- placing, HName, Length, DistTotal, RefNo 1...

Hi All, I have been struggling to write a query which will give me following results in field DistTotal as shown where: RefNo field is variable For placing 1 Default of DistTotal Value = 0 For placing 2 Default of DistTotal Value = Lenghth Value of placing 1 For placing 3 Default of DistTotal...

I am from India. I have been extensively using MS Excel and wrote many macros successfully. I gathered lot of knowledge from Excel Forum. I have very recently started using MS Access and hope to learn more about it. Warm Regards, Kamal