Search results for query: *

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

OK, thanks! I'm on my way out the door right now so I won't have a chance to try anything until tomorrow sometime. Bear

We have an inventory database that stores a record of each transaction using a number field called "audit_trail" which increments for each transaction. Each transaction also includes fields for the posting period which corresponds to the month (i.e. January = 1, etc.), the year, and a...

Arden, Thank you for your suggestion. I have just tried it and it is basically (sp?) what I have done in the past. It still doesn't work. I have even reinstalled Access and it still won't work. I'm running Access 2000 SR1 on Windows 2000 Pro, if that info helps. Thanks again, Bear

Dear friends, I am having a little problem displaying help in Access 2000. When I try to display help, I get the message “Microsoft Access can’t display Help. An error occurred and this feature is no longer working properly. Would you like to repair this feature now?”. I have tried to repair...

Yes, it can be done. I've got both on mine. You'll have to put them in different directories, though. Look in the Access: Other Topics FAQ for links and stuff that will give you more detail Bear