I have a query that uses IIf statements to calculate a point system from current horse shows based on place and number of entries. This is the query: SELECT...

I have a form that captures a lot of information on actions involving different products. This information is organized in a datasheet subform where each line...

I can create a pivot table to show data from a query in the view that the user would like to enter the data into. However, the pivot table will not let me...

I have a query that goes like this: SELECT Avg(!) AS FROM ; I assume that this is going to add all the fields in the CurrentSteamflow column and average...

Hi! I' m trying to build a report based on a select query. One of the querys fields states a price for a date series. I would like to retreive to my report...

With respect to my earlier post, I am trying to find the best way to dynamically alter the select list of a query. Any suggestions!! Cheers -- Regards Ashley...

I have a database with student names, student id numbers, parent names, a family number and email addresses. Every student in the school is listed multiple...

How do I use criteria to show or not show a fiel, for example, I have an IIf function: IIf(!!="Text",(.)=True) I would only like to show this field when the...

I am using Office 2003 on Windows XP. Please note that the use of spreadsheets is per boss and user preference - this is mandatory and beyond my control. I...

I'm trying to figure out how to make the results of one query be available as a dropdown menu prompt for the criteria of another query. Is there an easy way...

I have a database that is just huge, and at some point in time the company will have to archive the data in the tables, for the most part I can do this, the...

I have numbers like those below in a column of data I am using in a query. I need a formula to change it. 1013-14 123-1 1233-5 569 I need to get rid of...

I need to create an expression to total 2 columns. The 2 columns are Qunatity 2 and Quantity 3, I would like the 3rd coulmn to be Total Shipped:... Can you...

Hi Guys, I do an import of a number of spreadsheets and rather than simply append the data I want to update or add, anyone help? This is my code: Sub...

Hello all, I'm trying to create a query, but i've problem because i'm not an expert! I have these two...

Dear all, I am looking for some assistance with getting some information from a form into a query that goes directly to JET. Presently I am having the error...

Hi, I have two tables that contains almost the same information. The only difference is that one of the tables (Dagsrapporter) has about 400 more records than...

I need to check a large amount of sequential data for duplicate items, missing items, start and end of sequences, and other anomalies. The approach I am using...

I have a subreport that is based on a summary query that is based on the same query as the main report. It is my date parameter "Between And " that pops up...

I want to change number datatype to text datatype in quary design grid. I used CStr(number) function. It did not work. Why not? Text is a string datatype? Any...