Search results

Hi All I would like to force order of query results so I could use the output directly in Excel as chart data. The query returns cost categories with total cost per category: distribution 50 duties 20 manufacturing 60 warehousing 40 is there a way to force certain...

Hi All I am struggling with a table design. The table have the following fields: market_id, cost1, cost2, cost3, submitMonth, submitYear Markets will submit data on monthly basis and the data will be appended to the table. However a few markets will submit data on quarterly basis and some...

Hi All I have number of queries to create where I would need to summarize all the fields. Is there a way to change "total" field value in query design to "sum" in one go or do I have to do it field by field? Similarily is there a way to change a property of all fields in a table in one go? For...

Hi All, I have a simple query which throws an error (as in subject) on run. SELECT tblItemMaster.SKU, tblItemMaster.MaterialDescription, MonthName(Month([LastRevision])) AS [Month], Year([LastRevision]) AS [Year], tblItemMaster.LastRevision FROM tblItemMaster GROUP BY tblItemMaster.SKU...

Dear All I am using the below expression in an update query: iif(( ([tblItemMaster]![RuleMet1] = "Yes" AND [tblItemMaster]![RuleMet2] = "No") OR ([tblItemMaster]![RuleMet1] = "No" AND [tblItemMaster]![RuleMet2] = "Yes") ), [tblItemMaster]![ItemQualified] ="No", "") I have records in...

Hi All I am using an attachment type field in one of the tables. I have a query on this table that and I would like to use it output as a source data for a subform. Here where the issue is: it seems that I can't add one field representing the file to be visible in the form. There is number of...

Hi All What I am trying to achieve is to ask a user for a month number via inputbox and then use this value in update queries - see the below piece of code. The problem is that I would like ask user once at the beginning and re-use the value provided. However inputbox is called each time...

Hi, I am executing a simple update query: UPDATE tblMatrix INNER JOIN qrySelectMaxDate ON tblAll.SoldTo = qrySelectMaxDate.SoldTo SET tblMatrix.LastInvoicedDate = [qrySelectMaxDate]![MaxOfInvoiceDate]; and I am receiving an error "operation must use an updatable query". Googled it but not of...

Hi All I have address table with the following columns: location_name address1 address2 state_province city postal_code country the problem is that city details are all over the place (it can be within address1, address2, state). I have another table that has cities of the world (two...

Hi All I have designed a form with a few text and combo boxes. Values from those fields are used as parameters for a query which results are returned into a subform. Now I've added a checkbox to check if a product comes from US. The value of the checkbox is passed to the query as well (against...

Hi Everyone, I'm trying to import a table from Oracle database using : file --> get external data --> import I've configured ODBC connection and i'm getting to the stage when i can select tables from the Oracle database. But after submitting my selection I'm getting an error saying: ODBC...