How to access the value of a field of the current node in Drupal?

Microsoft Access Project 1 of 2 (Basic Skills)

• Within about the next Six hours of posting this I am seeking someone with the abilities to do an Basic difficulty Access project. The project has 2 steps to be built on from the file posted below. To access the Access file please go to http://myphlip.pearsoncmg.com/cw/mpchapter.cfm?vbcid=7937&vsubmit=Go and download Project Files - Project 9 - Project9.zip To view the Assignment and Steps please go to the same page but download the powerpoint slides titled .... PowerPoint Presentation by Gene Mesher and Robert Jamieson - Project 9 - mcleod9e_pr09.ppt The assignment and example of finished product is on the 33, 34, and 35 page of the slides at end. Rules: Please upload the file somewhere and provide the link so I may download it directly or provide another way for me to download the file AND post the SQL for each of the queries. Steps: (They are at the end of the power point slides) 1) Make a form for the CLASS table. Place both the ClassNumb and Enrollment fields in the form. For the Enrollment field form on the form, create a validation rule that the value must be less than or equal to 200. When the validation rule is violated a message should appear stating ^Enrollment Must Be Less Than Or Equal To 200.^ 2) Make a report of books used in each class. The finished report should look similar to Figure P9.25. Note any changes in labels from the default field names. Move the labels ^Sum^and ^Grand Total^to be on the right-hand side of the totals. Make sure your fields are wide enough to show the entire field value, that is, do not let the book titles get truncated by fields that are too narrow. Make sure your report design does not go past 6.5 inches wide which would cause blank pages to appear. I am posting another Access Project shortly which will be more difficult.

• Answer:

  Alwaysrelaxed, There is no SQL to post for this one, but your mdb file with the form and report are at: http://www.hammerdata.com/Google/Textbook.mdb - Hammer