Recent content by Jules Decouls

Hi I am trying to use an iif statement to limit the results of a query based on the value of a record. This is the criteria in the query field CTRID (centre ID) =IIf([Forms]![POMSfrmMainMenu]![Centre]=0,>0,[Forms]![POMSfrmMainMenu]![Centre]) when users login their login details are stored in...

Hi, I have an Excel sheet for a customer with a list of products in the first column and then their stores A, B, C etc. in the next columns. They place numbers in the relevant store columns of what each store wants to order against the product row. How do I manipulate this sheet into Access so...