Recent content by mikefortune

Thanks all. I just found a wealth of info on AS/400 stuff. All this time I thought as/400 was and OS not the architecture. I have recently learned the differences. Thank you for the help all. I now need some dummy books on as/400, any suggestions? Thanks.

Can anyone explain to me if there is a difference between AIX and AS400? And if anyone knows about an AS400 emulator where I can download it? Thanks

Hmm.. interesting. I am running a scsi hotswap system. I am removing 2 4 gig drives and replacing them with one 18gig, I wonder if it is pointing to the wrong place, not sure how that could happen, but it makes sense. It booted fine until I restored everything. Thanks. I will take a look.

Can anyone help me on this restore problem? I have a system that is backed up each night by NT's backup utility. I bought a new drive to replace the old C:After loading NT 4 on the machines new drive I did a restore from the backup tape I made, i set it to restore everything: File permissions...

I am getting ready to go too. Thanks for all your help. Maybe if you get a chance some other time you can help some more. I tried adding it as another field, but I need them grouped. There are records with identical data except the date which makes those records need to appear as one with...

oH! GOD I am so screwed! Now, when I add that field it gives that same message about being too complex. I take grouping off but that defeats the purpose of the query.

YOU ROCK BIG TIME man! I just put that expression into the first query and it worked great! Now, I just need to place the field in the second query and I will be set!!! I Love helpful people! It worked!!

SELECT orders.QhdrProspectName AS Customer, orders.QlinItemID, dashes([QlinQuoteLines]![QlinLineDescription]) AS Expr1, orders.QhdrLocation, orders.QlinNatlNetPrice, Sum(orders.WEEK1) AS SumOfWEEK1, Sum(orders.WEEK2) AS SumOfWEEK2, Sum(orders.WEEK3) AS SumOfWEEK3, Sum(orders.WEEK4) AS...

not sure what you mean by that, sorry to be difficult.

Oh wait, I got it to work, but now I got the same dang message about expression being to complex.... Paul can I send this database to you for you to look at and maybe see what I've done?

Paul you rock. But this just doesn't seem to work. You may need to hold my hand on this one. I went to the modules menu, selected NEW, then I pasted what you typed into that. I already have one module in there for converting dates...it works. This one still gives me the undefined thing. I...

Man that looks great, but when i went to run it, it gave me the error: Undefined Function 'Getdashes' in expression. I will be the first to admit, I am not familiar with modules and the VB side of access, but what I did was created a new module and copied what you typed into it. (I did...

For instance, the field contains alphanumeric data. In that data should reside a color surrounded by dashes. For instance... 10% Flannel 30% Jersey 60% Cotton - White - Spun poly I am looking to extract the color "White" into it's own field for a report.

I actually am only running this against one query which was run against 2 tables. It isn't that big of a dataset. Thanks though, I can't seem to think of another way to get the information I need from the field. THANKS!

The following error is one I got when making what I would think is a simple expression: Expr1: InStr([STARTPOINT],[DESC1],"-") I am pretty sure it is not typed incorrectly, just that it may contain incorrect statements. "This expression is typed incorrectly, or it is too complex...