Recent content by huggybear

That's right, how gauche of me. Please forgive me!

PHV, You are right, I made an error in transposing the SQL and it works just the way I intended. Thank you so much, Bear

PHV, Yes, that's what I thought too, but as my samples show for some reason it won't match the right price to the date of the transaction. Take a look at the transaction for 1/21/2007. The price should be $2.05, the price that went into effect 1/19. Thanks, Bear

Thanks PHV for your interest. That is the tack I was taking but my problem is that I need the P.Price that was in effect on the date of the transaction. Your suggestion yields the most recently entered P.Price. For instance, if transaction t occurred on 1/15/07 and on 1/16/07 the price changed...

I have 2 tables, Price (Date, Price, SiteID) and Transaction (Account, Date, Site, Quantity). Price is updated periodically as changes occur, could be many days between changes. Transactions can occur many times a day. I need a query to match the transaction with the price for the date and site...

I must be losing my mind. You guys nailed it. Thanks for your help. Bear

Please help me. I am having difficulty assigning values to array elements. When I use this method: Dim y y = Array(7,6,5,4,etc) I get an error when I try to compile, "Invalid outside procedure" I get the same error when I use this method: Option Base = 1 Dim y(4) As Integer y(1) = 1 I...

Thanks for the ToText idea. It worked great. You're my best friend for the rest of the afternoon.

I'll start by saying I'm new at Crystal but have a lot of experience with VB and VBA. So, I'm using Basic syntax in 8.5 because that's what I'm familiar with. My problem is that I need to manipulate integers to construct an account number with a check digit at the end and all my numbers wind up...

I think I see what the problem is. I am unable to register a server to connect to. I'm trying to figure that out now. If you can help me there I'd be grateful, but I am thankful for the help you have given so far. Bear

I'm pretty sure that's what came with my Developer's Tools. What I don't know is how to install the server part of it. The client part installs but there are no servers for it to connect to. Bear

Thanks to you both for replying. Well, no I don't get to decide the version and I haven't seen it yet. I was just hoping to get some practice creating views and stuff with the sample database that comes with it. SQLDenis, what is the $50 dollar developer version that you mention? Will it run on...

I have been developing with Access 2000 for several years now and have an opportunity to do some SQL Server work coming up. I loaded the SQL 7 cd that came with my Office 2000 Developer's Tools to see what I'd be dealing with and found that I couldn't make the standard installation, only the...

Thanks LB, that worked like a charm. Turns out I couldn't figure out the Basic syntax so I went ahead and used Crystal.

I'm using Crystal 11 to query an Access 2k database. I have quite a bit of experience using Access and its built-in report tool but am very new at Crystal. The objective is to get a total of billable hours of several technicians. In the report I have a formula (@Money) to calculate the billable...