Search results for query: *

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

I am use to Crystal Reports and assigning variables in the expression (formula) builder, i.e.: numberVAR = BLAH I have a very difficult expression in Access and it tells me that it is either to complex or something and try using variables. How do I assign a variable in Access? I will show...

You are correct sir! THanks, I found it 2 minutes after posting this. Thanks a ton, you had the right answer!!!!

I keep trying an if then else and it keeps telling me &quot;a number is required here&quot; when I check it. here is the formula: If {OELIN.Itemkey} <> &quot;FREIGHT&quot; and {OELIN.Qtyord} >= 1 then {OELIN.Qtyord} else IF {OELIN.Itemkey} = &quot;FREIGHT&quot; then &quot;&quot;

I actually found it. To get a single set of quotes in as part of text, it has to be four sets of quotes i.e.: Field1+&quot;/&quot;+Field2+&quot;&quot;&quot;&quot; That's the answer thanks!!!! all.

How do I use just one set of quotes in a formula as a text item. For instance, I want 2 fields added together with a / between them and at the end of those fields I want a &quot; added to that. Crystal keeps telling me the set is incomplete basically. Any ideas?