Search results

hi, instead of providing validation at the client side or in the server script.... cant i provide validation in the tables fields... I have a field named YearID, datatype text.. But I want to allow only text like this ==> e.g. 'F-00' 'F-01' Do I have to put any format property...

hello all, I have got 3 tables for employee training programs Employee TokenID (pk) Name Division Training_Program Prog_ID (pk) Cost Employee_program Serial_no TokenID (fk) Prog_ID (fk) Training programs are conducted for all divisions.Employee from two divisions can also attend...

ok...I have to display all the fields within Employee table . The fields of the Employee table keep changing. Even the count of fields can change. but I want to display whatever fields are present in the Table, except TokeniD (pK).. so in the the query cant mention the name of the fields...

how do i display all fields in a table, excluding a aprticular field sumthing like Select * from employee ( except tokenID) please do help thank you

Thanx a lot it works perfect.

helo al, I have two tables Employee TokenID (PK) name location post .. ..etc Rating TokenID (PFK) FinalScore I am trying to display all the fields from Employee table where Employee.TokenID= Rating.TokenID but I only want to display the fields from the Employee Table and not from...

Thanx alot.. Is there any way I could update the column values to unique random values...instead of the same value....and i also need double type number is this query right? UPDATE PMRating SET PMRating.H1 = dbl(Rnd(1)*3)+3

hello all I am trying to set column values to a random number between 3 and 5 PMRating TokenID: text H1: double YearID: text UPDATE PMRating SET PMRating.H1 = (5+3-3)*Rnd()+3 This shows type mismatch error . What is the problem here.. please do help...Thank you

exactly...i got that... But the crosstab query gives me much more scope of producing results based on different conditions.. thats why i said...its not giving me completely what i want....but atleast i learnt some new method.... thank you..

Thanx buddy....i have found a way to do it... Using crosstab query...Thats much more easier... Your suggestion was great...but i guess for a novice like me it will take some time to understand....Anyways for now i have the solution, but i would definetley try to device some method..the way you...

Wow this is getting better and better... But how do i join the crosstab queries.....could i do it by design view .. I really have no idea about the syntax of joining crosstab queries.. Thanx a lot....

Cool thanx a lot man... In this crosstab query you can incude only one table or query....rite.. any chance i could include more tables or queries..by some modification.. Thanx a lot..

In case you are just checking one month...use this SELECT tblpayments.memberid,"& Request.Form("month") &" FROM tblpayments WHERE ((("& Request.Form("month") &") Is Null)) here request.form("month") ......'month' is the listbox name.... put your listbox name instead of 'month'.. This would...

I have a two tables in my database related to employee ratings Employee TokenID Division Band PMRating TokenID H1 Now this statement SELECT DISTINCT Employee.Band FROM Employee This would display me all the band levels within Employee table in each row.. Is there any way I could built a...

hey guys.... I am still stuck with this problem.... any solution remotely close to the problem is also welcome... I reallly need this to work... please help...

yes I tried that.....here it is this shows me all bands/posts... SELECT DISTINCT Employee.Band,Avg(PMRating.H1) AS AvgOfH1, Count(Employee.TokenID) AS CountOfTokenID FROM Employee LEFT JOIN PMRating ON Employee.TokenID = PMRating.TokenID GROUP BY Employee.Band; this returns me all bands/posts...

hello all, I have two tables related to employee and his ratings.... Table: Employee ----------------------- TokenID (pk) Division Post Table: PmRating ----------------------- SerialNO TokenID (FK) H1 In this organization there are 5 Posts Some division may have all 5 , some may have...

oh ..please come on....please sumbody help.... Any input would do....i could think of sum alternative from that.... Thanx a lot

Thanx man Extracting all the posts in the organization is possible ...but how would i be able to link it to the average rating that I am calculating for evry post in that particular division..... The problem here is that evry division dusnt necessarily have all 5 posts... so the number of...

Thanx a lot.. Well i cant afford to add another table...coz that would need updating in the future...so evry time there is an updation in the number or type of posts then i'll hav to create provision for that....its not tough,,,but this increases my reqts for the project... By the way what does...