Recent content by Mr Frog

The problem I am having is that Format (n, "##0.00") will not produce the value of n to the query view. If i put "text" in place of "Format (n, "##0.00")" it will produce "text" to the query view. So how do I get it to produce the value of n?

Thank you that did help. If its ok I have a couple of other questions: Could someone tell me what I am doing wrong below. I am just told to solve for n given the equation below with values from a table between 0 and 99 accurate to two decimal places and my statement does not seem to function as...

If I run either of the following query's (I get the error below): insert into l_employees (employee_name) select employee_id, employee_name from names_view f, l_employees l where l.employee_id = f.employee_id order by employee_id; or insert into l_employees (employee_name) select employee_id...

Yes, you are absolutely right, but I am following the lab as written and they want me to take the generated data from the "View" (saved access query) and insert it into the newly created table column. I don't why they want it done this way, it may be just to teach us basic command syntax. Would...

I'm currently taking an SQL class and its all being done on MS Access. I've done well so far but have now hit a section where I am stuck. The question on the lab was: "List employee id and the names of all employees. display the names as first initial then last name followed by a period after...