Search results

Hi, I've designed a UNION query to gather a field (corresponding to a monthly rate) from 12 queries (one for each month). The goal is to use the UNION query as a basis for displaying a graph, showing the evolution of the monthly rate througout the year. To do so, I've UNIONed the field [Rate]...

Hi, I'm struggling with a very formal, not to say aesthetic, problem on one of my form used as a progress bar. This form is very simple, it contains only one unbound control that is called "Percentage". It displays the percentage of completion, when launching a report based on a somewhat...

Hi everyone, OK, here is my trouble (I use Access 97) : I designed a crosstab query based on a select query that requires parameters to be entered via a form. All parameters have been declared in the crosstab query. Parameters were given different types of value : numeric, text, date or...

Hi, I'm back again with a problem I've been struggling with for weeks, without being able to find any satisfying solution. Here it is : I designed a crosstab query based on a select query that requires parameters to be entered via a form. All parameters have been declared in the crosstab...

Hi, I have a crosstab query based on a select query requiring parameters to be entered via a dialog form. Everything works fine when the parameters are typed directly via a dialog box (select query and crosstab query run perfectly). When using the form to enter the paramaters, only the select...