Search results

Hi I have an excel spreadsheet with multiple columns. One of the columns has multiple values, which I want to become a list column with multiple values. I have separated the data with ";", but when I import the list value is either "null" or all of the data including the ";". It is not...

Hi The 4 group tables have to be separate as they each have a multiple toggle list in them. So I have three IIf statements in my query between group a and b then between group c and d. The third IIf statement is between IIf One and Two. This seems to have worked. The IIF statement gives me...

Hi Have four columns in a query. Columns are text. Want to do an IF statement - would usually do a IF(ISTEXT)) in excel. So in my query I have started with the following: NewStyle: IIf([GroupA - Quantity]![Inventory.Style]="",[GroupB - Quantity]![Inventory.Style],[GroupA -...

Don't worry - sorted.

Hi I have a table with multiple Yes/No options. Same table also has a column for quantity. The unique id is style code. New query - with quantity and an expression to multiple the SUM of YES/NO * quantity. Yes is a negative number, ie -1. Making my sum a negative number. Any way I can...

Hi I have many tables - unrelated - I have set up a delete query for all tables, and now want a simple macro to run all the delete queries. (preferably without Displayalerts). I just want a simple Access macro which can easily be updated should I delete or add tables going forward. Thanks

Hi I have an extension on this issue. I have many tables - unrelated - I have set up a delete query for all tables, and now want a simple macro to run all the delete queries. (preferably without Displayalerts). I just want a simple Access macro which can easily be updated should I delete or add...