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...

Thanks. Got your point, it makes sense. Will re-think the data structure.

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...

Thanks for that. I will check if the data type can be changed to "date/time".

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...

thanks guys, MSAccessRookie...now it's clear. Thanks for your help

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...

Thank you. Will take a look.

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...

Good points. Thanks again

Thanks again. You've put me on the right track. it should be: tbltexDataArchive.Month_name =" & "'" & MonthName(monthNumber) &"'" & " instead of: tbltexDataArchive.Month_name =" & MonthName(monthNumber) & "

Thanks for the suggestion. Once I've seen it I thought it's going to work. I still get an inputbox once SQL line is executed (now it has a month name as title). SQL line looks as follows: sqlString = "UPDATE tbltexDataArchive SET tbltexDataArchive.Month_name =" & MonthName(monthNumber) & "...

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...

Sorry, i wasn't clear. Thanks elliotgr, i've done that and it worked fine. Thanks for your help

Great, thanks a lot. Followed your advice.

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...

Thanks for that I'll look through the code and will try to apply it to my case. Thanks again

I'd be happy to do it with code. Would it be easier to do in excel than in access? What do you think? Would you have any suggestions? The only way I can think it can be done is to extract each element from the address field (the elements are 'space' separated) compare each element to the every...

Thanks nathansav My data is more messy. You can have street name, street number and city, all in one field "address1". What i'd like to do is to check if a part of the field value is a valid city name (compare against values from the city table). If it is remove it from "address1" and put into...