Recent content by kellstee

Thank you!

Thanks, ph. That gets me close. My only problem is that I then have over 100 columns and 100 rows which still makes it difficult to read. Is there a way to get the time in the data field instead of making each time a seperate column?

We have an app that holds lots of records - the record tells the app what report to run at what time. So, it looks like this: Report Run Time ------------------- A 9:15 B 9:35 C 10:45 D 9:16 E 8:12 A 20:15 B 21:15 A 7:00 D 8:00 F...

Anyone have any other ideas?

Thanks for the response, Remou. The first method in the article doesn't work for me. My "primary key" is a date field and the dates can sometimes vary. I used the second method and it does work for me, just not on a calculated field in the form (I calculated Ending Balance in the form). I...

I have a form with the following fields: Beginning Balance, Additions, Subtractions, and Ending Balance. Additions and Subtractions comes from a query, Beginning and Ending balance are derived (Beginning Balance on the first record comes from a table). Ending Balance is just calculated...

Duh. . .that makes sense.

Thanks for the replies. When I put the value in a form, the query only seems to recognize the form field when the form is open. Is this expected behavior? Thanks again!

THANK YOU!

I wrote my first pass-through query and it has several nested select statements. When I run the query, a window pops up asking me to pick the data source and I have to choose the appropriate ODBC connection. This box pops up 4 times in processing my query (I'm assuming due to the nested select...

Sorry, I know this is the most basic question and I've spent hours searching. I must just be using the wrong search criteria or the explanations are over my head. I have a value in a one-row table that I divide by the number of days in the current month. I need this value often for other...

Oops. That would be helpful. SELECT [COH].Account, [Closing Date], [Amount], (SELECT Sum([Amount]) FROM [COH], [Trial Balance] WHERE [COH].Account = [Trial Balance].Account and [Closing Date]<=[tbl_Alias].[Closing Date]) AS [Running Total] FROM [Trial Balance], [COH] as tbl_Alias WHERE [Trial...

I'm confused though as the first two columns in my result set come from a simple table. How can I force [COH].Closing_Date to be the current date for the Business Account in the COH table? So then every time the data is retrieved, that field will always be the current date? Not sure where to...

I have a query with a running total that sums up a bunch of credit card/bank accounts. This the result set I need: Account - Closing Date - Balance - Running Total ------------------------------------------------- Bus Acct - ??? - $400 - $400 VISA 1000 - 08/15/2007 - ($1500) - ($1100) VISA...

PHV, Just one more thing. . .my query is now taking quite awhile to run. This is the query. . .any ideas on how to speed it up? SELECT OrderNumber, o.ShipFirstName, o.ShipLastName, o.Status, b.Notes AS [Progress Notes] FROM [Bob's Notes] AS b RIGHT JOIN dbo_Orders AS o ON b.OrderID=o.OrderID...