Search results

I need to see Dummy = -1 only if there are no Dummy=0 records

I received an expression entered has invalid number when removing the " " I only want to see the Dummy = 0 if there are records with Dummy=0 else Dummy = -1 I tried the below but no filter has applied

Dummy is a yes or no tick box

Hi all, I want to use an Iff statement in a query If "Dummy" = false, then I only want to see all the record with dummy as false else, if there are no dummy = false in the records set, just show me dummy = True Basically I first want to filter dummy = false (10 records), if no, the I want to...

No I dont want to limit the product list If a product has a preferred supplier and the supplier is selected, the products for this supplier would be sorted to the top of the combo box only the products with the selected supplier must be highlighted The balance of the product available for any...

Hi all, I have a form where I select the Supplier In the product dropdown box, the product for this preferred supplier is listed on the top of the drop down box When the product dropdown list is selected and the supplier selected is the preferred supplier, I would like to highlight all the...

Thank you Much appriciated

Hi all, I am joining 2 fields with a special character in between when no data, I dont want to see the special character I use the below code but gives an error any suggestions, sure I am missing something small? When there is no data, the form displays correctly When data is entered i get...

Yes it is working perfect Thank you for the advice below my order Below the outcome

I have created the table yes

Thank you, This in not quite what i need If product 1 requires quantity 3 on an order I need to receive Qty 1 - Expiry date - Batch Number Qty 1 - Expiry date - Batch Number Qty 1 - Expiry date - Batch Number Each qty received requires a different batch number I dont want to tally as per...

Thank you very much[/CODE]

I am getting everything except 1 2 3 below is my sample data The output should be 1+1 for product id = 71 and 1+1 for product id 72 This is the output I get from the query

Not sure I understand This is my attempt

Hi All, Please could you assist? I need to create a query to multiply records in a new table After I have ordered a product that requires an expiry date and a batch number, i need to receive the product If 2 was ordered, I need to receive 1 and 1 to be able to add the batch number and the...

Got it thank you

The queries makes provision for any additional locations from the table should they be added The form only shows main office as available controls even though there are 2 other locations in the table and the query

I tried that but there is no addition control sources to select in the Form These are the only controls to select from when I select the query as record source

Trying to get this query into a form now also trying to have place holders for additional locations

Thank you so much