Search results

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

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

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

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

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

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

I have a form where you enter customer orders. You can enter multiple items. I have a field that sums the order. The total it not stored in a table, only on the form. I now need to query all orders for the year but can not get totals to show because the formula is in the form. I know this must...

Hello! I have a 97 version database w/ a query that pulls from multiple queries, I converted this database to 2000 for our subsidiary that is running 2000. In this query I prompt for the date [Month begin date M/D/YY]. After converting to 2000, in the prompt it now says “ [Month begin date...

I have a form that the sales reps fill out . I want to them to press a command button to email the current record in excel format. I can do the format but it will send all records. Something like this: DoCmd.DoMenuItem acFormBar, acRecordsMenu, 2, , acMenuVer70 DoCmd.SendObject acForm, "ECN...