urtrivedi

Post your table structure and sample data

Try using newline character "\n" after each line. But I am not sure whether email client will allow active html in message or not.

Your client is really very intelligent. I suggest you not to do any kind of reasearch on this project as you have only worked on MS Access. You must take some help from an experienced person. I think php-mysql platform will suit best to your clients requirement.

You can do it in following manner insert into table3 (pid,cid) select a.pid,b.cid from table1 a cross join table2 b As darkagn said, your case doesnt need this to be done. Its already there

If I had to design the database I would have done it in following manner. Project ([B]ProjectId[/B],ProjectName,Status) 1,Project A, Open Zone([B]ZoneId[/B],ZoneName,[I]ProjectId[/I],IS_VARIABLE) 1,ZONE A, 1, 0 2,ZONE A, 2, 0 3,ZONE A, 3, 0 4,ZONE A, 4, 1 Reading_hdr([B]ReadingIndex[/B],date,[I]ZoneId[/I]) 1,27-mar-2008,1 2,28-mar-2008,4 Reading_dtl([B][I]ReadingIndex[/I][/B], [B]srno[/B], ReadingType, F1, F2, F3) /* Reading type could …

You can do it using alter table table1 add (courseId numeric(10)) then [icode]update table1 set courseid=courseno[/icode] then [icode]alter table table1 drop "pkoldname"[/icode] then [icode]alter table table1 add primary key pknewname (courseid)[/icode] You can also user enterprise manager to do above operation using gui.

Triggers are generally of two types Statement level and row level. Right now I dont remember syntax. But if you want to create trigger at row level You can access values using inserted cursor and deleted cursor. if row is inserted new values can be accessed as inserted.col1, inserted.col2...... etc …