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: *

  1. VC2002

    Access Query From Excel

    Thanks a lot to both of you! VC
  2. VC2002

    Access Query From Excel

    Hi! I'm running a query in Excel from an Access Database. The table in Access has a date column and a price column, and contains about 3000 records. I want to limit the query in Excel to the 200 most recent records. Any ideas out there?! Thanks, VC
  3. VC2002

    Excel Database Query

    Hi! I'm running a query in Excel from an Access Database. The table in Access has a date column and a price column, and contains about 3000 records. I want to limit the query in Excel to the 200 most recent records. Any ideas out there?! Thanks, VC
  4. VC2002

    DSUM FUNCTION

    Sure, it's: SELECT tblPriceData.Date,tblPriceData.Close, (SELECT Sum(qryPriceData.Close) FROM qryPriceData WHERE qryPriceData.Date Between tblPriceData.Date-15 AND tblPriceData.Date) AS Rolling15 FROM tblPriceData; Thanks,
  5. VC2002

    DSUM FUNCTION

    The value it's returning in the 'Rolling15' column is actually the sum of the entire price column, and not the previous 15 days price data...
  6. VC2002

    DSUM FUNCTION

    Getting there! It's returning a constant value, not summing the previous 15 days each day. I think one final question: I don't understand where "yourTableB" and therefore "B.Date" and "B.Price" comes from. I've only got the one table with a "Date" and "Price" column. Is "yourTableB" the...
  7. VC2002

    DSUM FUNCTION

    Hi PH, Should I write your select statement in VB or in the expression builder? Thanks, VC
  8. VC2002

    DSUM FUNCTION

    Hi! I have an access table with a date and price column. I want to do a rolling 15 day sum of the prices in a query of the table, i.e. for every day, sum the previous fifteen days prices. I think the DSUM function in the Expression Builder is what I want, but I'm unsure how to actually build...
  9. VC2002

    PIVOT TABLE QUERY

    Hi Having problem with a pivot table Data looks like this Column1 Project Code Column 2 Category Column 3 Description Column 4 Location Column 5-16 Sept, Oct Nov etc There are $ amounts under each of the months On the PIVOT table I have Location as a Page field, Project, category and...
  10. VC2002

    PC Performance

    Hi, I'm not even sure if I'm in the correct forum, but here goes! I want my PC to be connected 24/7 to a datafeed that is received over the internet - will this damage my PC or slow it up? Is it bad for the PC never to log it off? Any help at all would be greatly appreciated! Thanks VC
  11. VC2002

    Monthly Summaries

    Hi! I have an access database table with daily data. How do I create a query (if I even have to create one!) to summarise this data on a monthly basis? Thanks!
  12. VC2002

    Sub Execution

    This website never ceases to amaze me, I barely had that post up 10 minutes and I've already got several replies! I'll give it a go and let you know how I get on. Thanks again!
  13. VC2002

    Sub Execution

    Hi! I want a sub to be triggered if an excel cell has a certain value. The cell is linked via a dde link that constantly updates. I want it to run overnight too, so it rules out just using command buttons. Any ideas? Thanks!
  14. VC2002

    Microsoft Word Headers

    That's great! Thank you so much, i've been trying to figure it out for hours! Regards, VC
  15. VC2002

    Microsoft Word Headers

    Hi! I've got a report that requires different headers for different chapters, all on the one document. For instance, pages one to 20, I want 'Chapter One' as the header, pages 21 to 40 'Chapter Two', etc. is this possible? Thanks!
  16. VC2002

    COMBO BOXES

    That's great Ramzi, thanks a lot for all your help!
  17. VC2002

    COMBO BOXES

    That's great! The format is perfect. Do you know how to set the combo box to the initial value, or a value that I specify? Thanks again for all your help!
  18. VC2002

    COMBO BOXES

    Sure, code is as follows: Private Sub UserForm_Initialize() cbxPeriodStart.ColumnCount = 1 cbxPeriodStart.RowSource = "S4:S106" cbxPeriodEnd.ColumnCount = 1 cbxPeriodEnd.RowSource = "T5:T107" End Sub Where "S4:T107" are my date values in an...
  19. VC2002

    COMBO BOXES

    Hi, I have a VBA form containing a Combo Box that reads in dates from cells in an Excel Spreadsheet. When I click the drop-down button, the dates are shown, but when I select one, its integer value appears in the box, how do I fix this so the date format appears and not the integer? Also, how...
  20. VC2002

    Excel Spin Buttons

    Thanks for the quick reply! Yeah, I've already tried that, and it does work but the problem there is when I go from 116.99 to 117.00 to 117.01, it won't work because the 'Max' property of the Spin button can only go to 100. It will go to 117.00, but not to 117.01 because I would have to reset...

Part and Inventory Search

Back
Top