Search results for query: *

Thanks a lot to both of you! VC

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

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

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,

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

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

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

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

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

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

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!

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!

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!

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

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!

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

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!

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

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

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