Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kellstee
  • Order by date
  1. kellstee

    Need help with query - can I make this row data into column data?

    Thank you!
  2. kellstee

    Need help with query - can I make this row data into column data?

    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?
  3. kellstee

    Need help with query - can I make this row data into column data?

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

    How do I grab the value from the previous record on this calc field?

    Anyone have any other ideas?
  5. kellstee

    How do I grab the value from the previous record on this calc field?

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

    How do I grab the value from the previous record on this calc field?

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

    How to have a field always hold current date?

    Duh. . .that makes sense.
  8. kellstee

    How to store field value in variable?

    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!
  9. kellstee

    Newbie Question about Pass-Through Query & Data Source

    THANK YOU!
  10. kellstee

    Newbie Question about Pass-Through Query & Data Source

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

    How to store field value in variable?

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

    How to have a field always hold current date?

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

    How to have a field always hold current date?

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

    How to have a field always hold current date?

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

    How to add a memo field for query to non-writeable db?

    ...AS b RIGHT JOIN dbo_Orders AS o ON b.OrderID=o.OrderID WHERE Exists (Select 1 From dbo_OrderItems oi Where oi.OrderID = o.OrderID and (Name Like '*red*' or Name Like '*blue*' or Name Like '*green*')) and StoreID = 1 and o.Status<>"Shipped" and o.Status<>"SP" and o.Status<>"Claims"; I think...
  16. kellstee

    How to add a memo field for query to non-writeable db?

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

    How to add a memo field for query to non-writeable db?

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

    How to add a memo field for query to non-writeable db?

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

    Barcode Scanner Recommendations?

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

    Code 39 HIBC standard

    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

Part and Inventory Search

Back
Top