Recent content by gutmj

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