Search results for query: *

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...

Thanks! I've known about joins for a long time, however, never really understood when I would need one and now I totally get it! Thanks for being patient with me! Kelly

Well, my query returns order data like this. . . OrderID 1, 2, 3, 4 Tomorrow since there may be some new orders and some cancelled ones, it will be OrderID 1, 2, 3, 5, 7, 8, 10 So wouldn't I need to first create [Ralph's Notes] table with all of my orderid's in it and a blank "Notes" field...

I wrote a query to show orders and their due dates using a ODBC link to our orders database (the db is sql server if it matters). We're not able to write back to the database (or just really don't want; we would hate to screw something up). One guy who handles the orders would like to have an...

I guess I didn't really understand what a bar code scanner was when we first shopping for one. I took Doug's advice and found a used on on eBay for less than $100.00 and it came with a stand. It works perfectly and I saved a lot of money.

DougP, Is there a way to contact you? I saw in a previous post that you maybe sponsored one of the forums and to find the link and contact you that way. However, I'm unable to find any sponsor links. Maybe that's really old information. You can contact me at kellystee@hotmail.com. Kelly