Search results for query: *

Thanks Dan JR. I used your explanation above to craft a couple of queries that got me what I wanted. I first got the last result by team. Then I got the StatID of the last record that didn't match the last result. Then I counted the number of StatIDs between those two records. Sorry for the...

Not exactly. Your solution would give me each team's overall record. I already have something that does that. What I need is something that will sum wins, losses or ties only if they are consecutive. Like, if Team 2 has played 5 games but lost its last two, the streak would be 2 losses.

I have a table with teamID, SchdID, Win, Loss, Tie as its fields. I'm trying to write a query that can give me each team's current winning or losing streak. Eaxmple TeamID SchID Win Loss Tie 1 20 1 0 0 1 30 1 0 0 1 40 1 0 0 2 21 1...

Thanks. I used Mac's solution and it worked.

I asked a similar question earlier but now I'd like to explore some more functionality. I have 2 combo boxes on my form where the user selects the Starting_Period and the Ending_Period. I'd like for the Ending_Period to default to the last entry in my tblPeriod (I maunally add to my...

thanks. That worked.

I have a form where the user choose the Starting MMM-YYYY and Ending MMM-YYYY. I'd like to set the default value for the Starting Period and the Ending Period to Jan-Present Year and Dec-Present Year. I've tried to use the following code on the OnOpen event procedure of the form but I think...

It's definitely Access 2000. And, it's an installation here at work. I don't have the install cd. My Access DB is being accessed by users in a varity of places so fixing it just on my pc and not everyone else's is not going to work. I did a search on my pc and I only found Graph10 files...

AceMan, Thanks for all of your help. I went to the Object Browser and I found the ChartTitle property under the graph library. I read the help and it suggested to use this code: With Me.AvgPriceGraph .HasTitle = True .chartitle.Text = "Trailing 12 months Average Unit Price for Part # " &...

I've tried several different versions of the above code and it sill does not work. I keep getting the error "Run-time error '1004' Unable to set the Text property of the ChartTitle property" It is as if it does not recognize the ChartTitle property. The filename is C:\Program...

We run Access 2000 here. Here is the code that I have: Private Sub AvgPriceGraph_GotFocus() Dim Chart As Object, Txt As String Set Chart = Me!AvgPriceGraph Txt = "Trailing 12 months Average Unit Price for Part # " Chart.ChartTitle.Text = Txt & Me![Part#] Set Chart = Nothing...

Sorry for the late response. I did use the correct chart title. But, I did not set the reference library. So , I set it to MS Graph 10.0 Graph Library. But, when I tried it, I still get this message: "Run-time error '1004' Unable to set the Text property of the ChartTitle property"...

I tried and got this error message: Unable to set the Text Property of ChartTitle class not sure what that means?

I have embedded a chart on a form. I am having difficulty with its Title. I want the Chart title to say: "Trailing 12 months Average Unit Price for Part # XXXX". The user selects the Part # on another tab on my form. How do I get the actual part number to show up in the title? I have...

That's it. Thanks

I have a table with Vendor#, VendorName and Status. The Status field has either OBS (Obsolete), NA (not available) or is blank. I am trying to write a query that displays all Vendor# when Status field does not equal OBS or NA but, I can't get it to work right. My problem is the WHERE...

These particular records have PartNo, Vendor01, Vendor01PurchaseUnit, Vendor01InvoiceDate, Vendor01InvoicePrice, Vendor01ListPrice, etc. And those same fields are repeated for Vendor02 and for Vendor03. I don't see/understand how normalizing this will prove to be any better than they way it...

Sorry. I have been away for a long weekend. I don't think you guys totally understand my table structure. In the current system, one part number can have up to 3 vendors assigned to it. So, I do think the database is normalized. I can't (nor do I want) to go back and set up the table such...

Leslie, I don't understand what you mean by 'Normalized data structure', but, I am going to read the document you linked. And, by the way, I don't have the ability to change the table structure b/c it is a 'data dump' from our archaic mainframe. Thanks

Sorry guys/gals. I found my answer after scrolling through some of the threads in this forum. My SQL looks like this: SELECT PPSC.ItemNo, PPSC.FullDescription, * FROM PPSC WHERE (((PPSC.Vendor01)=[forms]![frmNetSavings]![lstSupplierName])) OR...