Recent content by Lucy R

Hi Still having troubles. I dont have a command button so I opted for the query option. I inputted: (SELECT * FROM [Resources] WHERE [Specialist Subject] <> null) into the criteria box but then I had pop-up help message saying the following: "You've written a subquery that can return more...

Thank you Nishant, it worked perfectly! The -1 is a great thing to know. In fact it helped me solve a couple of issues. Can you help me on this question? I have a table with Employees names and their specialist subjects, however some employees do not have a specialised subject so i dont want...

Hi I am not a compuer whizz and I don't understand what Rich explained below. Anyone able to explain in simple terms for me please? Cheers, Lucy

Hi Nishant Thanks for the advice. I have tried but with no success, here is some more detail and a clearer explanation (I hope!!); I have a column in the table which is a text box named 'Ordered' in which I type 'Yes' or 'No', depending on whether the project is ordered or not. In the same...

Hi In a report I have a group header that sorts the report information into 2 sections depending if the the project is ordered or not - =IIf([Ordered]="Yes","ORDERED","FORECAST") In the 'Project Status' column I want it to show 'Project Stage if the product is ordered and to show 'sales stage'...

Thanks for your help - it worked!!!! Brilliant! One more question though. I now have a another report in which I don't want the zero values in one field to show. This is not a Yes/no field but a Text field in a combo box in a Table (the text options come from another table). In my query...

I am a relatively new access user (started 2 days ago!) and have been learning as I go with the aid of the Help key. I have become stuck on the question below: I have the following expression in a text box in a Header in a report =IIf([Performance Manager?]="Yes","PM Product","NPR Product")...