I am using MS Access as a front end for my mysql database (haven't learned enough about php yet to switch). I have a query called "frmq- expenses" based on the table "expenses" that includes fields named expensecode, cost, quantity, description, etc. The query calculates the totalcost field by multiplying quantity x cost. When I use an expense code "labor" or "rj45end" I get mysql errors. First error is that the total cost calculation won't work. Second error is when I try to move out of the record, it states ODBC --update on a linked table "expenses" failed.
Is this because my expense code contains words that are "reserved"? If so, is there a way to continue to use the codes by bracketing something within my code? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "PHP & MySQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/phpmysql?hl=en -~----------~----~----~----~------~----~------~--~---
