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

...Price 1/15/2007 002 $2.08 1/15/2007 003 $2.08 1/17/2007 002 $2.06 1/17/2007 003 $2.06 1/18/2007 002 $2.07 1/18/2007 003 $2.07 1/19/2007 001 $2.05 * 1/19/2007 002 $2.05 1/19/2007 003 $2.05 1/20/2007 002 $2.09 1/20/2007 003 $2.09 1/22/2007 002 $2.18 1/22/2007 003 $2.16 1/23/2007 002 $2.18...

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.

...the mid function like this: for i = 1 to len(strAcctNum) Redim Preserve x(i) x(i) = fix(CDbl(mid(strAcctNum, i, 1))) z(i) = fix(x(i)*y(i)) if z(i) >= 10 then dim j as number j = fix(z(i)) z(i) = fix((j mod 10) + (j\10)) end if strAcctChkNum =...

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.

...as double hours = Sum ({TransService.ServiceHours}, {TransService.ServiceTech}) regular = 40 rate=68 if hours <= regular then formula = hours * rate else otime = hours - regular formula = (regular * rate) + ((hours - regular) * (rate*1.5)) end if That works very well. Now...

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 &quot;audit_trail&quot; 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