Search results for query: *

The table have total 17547 records. Below query returns 1980 records: SELECT DISTINCT [mytable].[SUB NO], [mytable].TAX, [mytable].DATE, [mytable_1].TAX, [mytable_1].DATE FROM [mytable] INNER JOIN [mytable] AS [mytable_1] ON [mytable].[SUB NO] = [mytable_1].[SUB NO] WHERE...

Needs some help to rewrite this query so that memo field does not get truncated: SELECT DISTINCT ServiceRecords.ServiceRecordID, Customers.CustomerName, ServiceRecords.CustomerID, Orders.PONumber, OrderItems.ItemNumber, ServiceRecords.SerialNumber, ServiceRecords.ProblemDescription...

Here's my query that returns what I need. This query sorts the tblContribution.Type in ascending order: PARAMETERS [Forms]![YearlyReport]![Start] DateTime, [Forms]![YearlyReport]![Start] DateTime; TRANSFORM Sum(tblContribution.Amnt) AS AmntOfSum SELECT tblContribution.Type...

I have a query which returns expense date (ExpDate). I would like to group the ExpDate by months: 2004/01, 2004/02, 2004/03,...,2004/12. Then I want to display the months as columns. But I can not think of a way how to do it. Help. Below is the query statement that selects departments and...

On a report, I have a textbox. I would like the textbox's data source be a query result. For example, the query statement is "select sum(amount) from ExpenseTable". What's the work around?

I do not remember what I did with the formats, the page setup, or printer setup. For some reason, I get 45 pages of the same report page (with the same data). Has anybody had this problem?

I get the error message &quot;The Microsoft Jet database engine does not recognize '[forms]![ExpReport]![StartDate]' as a valid field name or expression.&quot; The filter expression is [Date] <= CDate([Forms]![ExpReport]![StartDate]) I found a thread with same problem, but it was posted on a...

I have a crosstab query that results to following report: DepName1 DepName2 .. ExpCat1 $10 $5 ExpCat2 $500 $250 .. : : : However, I want to add one more column &quot;Balance&quot; to result in the following report: DepName1 DepName2 ...

I have a table that resembles a bank transaction: transId, check#, pay-to, currentAmount, pay-date, etc. I have a report out of that table with one more field in it: balance. I want the balance field to be calculated as &quot; = previousBalance - currentAmount&quot;. I don't know how to do it...

I have a VB application that copies a huge file from one location to another. I clicked on another application while my VB app is copying. Then I clicked back on my VB app. My VB form doesn't show all the controls on the form. It looks the form.Refresh function doesn't work because the system...