Search results for query: *

Hello can anyone help me convert the following MS Access Query to a MySQL pass through query. INSERT INTO va_categories ( category_name, parent_category_id, category_path, is_showing ) SELECT First([va_c2k].SubCategory) AS [SubCategory Field], [va_c2k].cat1, "0," & [cat1] & "," AS...

Hello all, I have an Access DB connected to a MySQL DB using linked tables. In access I've got several various update and append queries and a local products table that help populate the MySQL DB. Everything works fine but it takes forever to run the queries. I was told that if I use SQL...

Hello I'm trying to do an update query by compairing certain fields. Here is the query so far, UPDATE [Enhanced-GB] INNER JOIN va_categories ON ([Enhanced-GB].SubCategory = va_categories.parent_category_id) AND ([Enhanced-GB].Sub_SubCategory = va_categories.category_name) AND...

Hello, I have a table in an MS Access DB with about 12 columns. It has about 35,000 entries and I need to upload it to a MySQL database. Before I can do that I need to change entries in 3 Columns and all 3 columns are linked. The first column was easy but the next 2 are a little more difficult...

In my report I calculate VAT for Invoices In and for Invoices Out with this formula. =Nz(Sum([AmountExVAT]*[VRate]),0) There is an InOut Header and the calculation is in the InOut Footer In the Report Footer how do I calculate the differnece between Invoices In and Invoices Out. And if the...

Hi a quick question. Is it possible to name a text box in a report based on other values in the report. Hope ye understand this question. If ya don't I'll try to explain better. Thanks

Hello everyone. I need some help with forms. I have a Continuous Form with 4 Combo boxes in the Header. I need Data Entry set to YES. And I need the values chosen in the combo boxes in the Header to be entered into the table INVOICES for all new entries of the Continuous Form. And no other older...

Hello to all. I am a newbe to this forum and to MS access. The problem I am having has to do with Continuous Forms. In the header of the form I have 4 Combo boxes. For now lets just work on one combo box. The combo box name is 'PYID'. The table name is 'Invoice' and the field name is 'PYID' and...