Search results

Hello, I have the following SQL query that runs perfectly. Now I need to put some blank spaces in between for the first expresion (EXPR1). At the moment, as you can see, brings me the 4 fields together. I have tried using + ' ' + and + " " + but it won't let me as it says that the syntax is...

Thank you Fofa, I will try what you suggest and let you know how I go Thanks again Gloria

Hello, I have a form where the user can choose from 1 to n countries from a list box and from there a report is run based on the countries the user has chosen. I am using a stored procedure to pass these parameters to the report; however I am not able to get any records. Any ideas why ? Thanks...

Hello gromit, I tried as you suggested and it almost worked but it sent me an error at the end and instead of getting the date I got "mm/dd/yyyy" :( however, I continued trying and found out that I needed to change in the properties of the text box the Default value and put...

Hello, This is problably a very simple question; however, I can't find the way to do it. I have a field in a form that its default value is today's date: Default value: Date(). As you know, it always appears as dd/mm/yyyy. Is there a way to change it and instead to appear as mm/dd/yyyy ? I am...

Hello, I have created a report that has input parameters (date in which the report wants to be accessed). Now I need that the user be able to enter other field from a combo box as well. Do I need to create another form where the user selects the information from the combo box and then send him...

Hello, This is a simple question. In my application I have the option of selecting different check boxes (6 different options). My database is storing the values 0 and -1 for nonchecked - checked boxes as it should be. Now, I would like to create a report to display which values were selected...