Search results

Got it! Thanks for the info namliam. Thank you both for your time. Very much appreciated.

Thanks Thanks Jon, works perfect!! I didn’t have a clue about Mod 12. Very much appreciated.

I am importing data to a program that requires the life of an item. This is in months such as 241 months. The valid format for this program is YYMM. 241 = 2001 or 20 years 01 month. Another example: 16 months should read 0104 or one year 4 months. Any idea how to convert this to yymm format...

AAH that explains it. Thanks so much for your time and help. Very much appreciated. Mahalo, Michael

I’m using an iff statement: IIf([Item type]="U",+1*Int(+1*[Gross]*1.03),([Gross]*1.03) Item type U needs to round up to whole dollar. The rest need to round up cents. I am using Access 97. I always get an error trying to use the Round function in the above statement so I use Int. This is not...

dident work I tried that but can't seem to get it to work in Access. Thanks any way.

I want to round up to whole number based on U. the else needs to round up to the nearest cent. i.e. 1.64 rounds up to 1.65. The first part works but I can figure out how round up the cents in the else part. IIf([Item type]="U",+1*Int(+1*[Gross]*1.03),([Gross]*1.03) Any help would be...

Wow! Very nice! Thanks for your time.

Ahhh.... it was the like "R"*! The IIf([Item] Like "R*",-[Total],[Total]) worked perfect! Thanks!!

I am trying to change a + number to a – number in a query based on an items first character of “R”. Can’t seem to get it to work. Here is an example of what I am doing. IIf([Item]=”R”*,-[Total],[Total]). I know this is wrong but I thought this would help illustrate what I am trying to do. Any...

Try this.. Creat a button and put Application.FollowHyperlink “name of field with link no quouts”

Right click queries properties in the grey and select unique records to yes.

Thanks for the direction! I just needed a little push.

I am attempting to build a QC parts inspected database and would like an opinion on the structure before I get to deep into it. This is what I am shooting for, three tables table 1: Part and vendor information. Table 2: parts rejected, reason etc. table 3: parts Accepted w/ deviations, qty etc...

Thanks Thanks! I think I see the light now. I really appreciate your help. Michael

I have a product return table and a code table. The product table was originally set up with 6 lookup fields for the codes as to there could be more than one thing wrong with the product. I know this is the wrong structure because of the redundant code information. The question is, How do I...

Hello, I have created a database that generates and issues part numbers via a request form. I now need to create a form that will creates 10 - 20 numbers at once for one person. Basically I am using the auto number system with a prefix added for the part numbers. How do you create or add say, 10...

Figured it out, thanks anyway.

I have a table of parts numbers. I have a table with 12 dates. I need to combine the dates and part #'s table and for each part number, list the 12 dates. For example, Part # Date 001 010203 001 020303 001 030303 001 040103 001 050103 001 070103 etc. etc. I could have someone key the...

Thanks! It worked!