Recent content by scootswiss

Here is my SQL statement so far; UPDATE TblMultiProfile, TblGenCartonsForAnalysis SET TblMultiProfile.CtnB = [TblGenCartonsForAnalysis].[Ctn] WHERE (((TblMultiProfile.L)<=[TblGenCartonsForAnalysis].[Lc]) AND ((TblMultiProfile.W)<=[TblGenCartonsForAnalysis].[Wc]) AND...

I am working on a process to select the best fitting carton for our product line. I have a table of all items item with the length, width, height and cube for each item in separate fields. I also have a table of our possible shipping cartons with the L, W, H and inside cube in separate fields...

I have an Access 2000 db that I have run the compact and repair tool on many times before. Today when using the tool in the bottom left of the monitor screen I can see it would run through compacting, but not repair. The status only completes 1/2 way and the word &quot;compacting&quot; stays...

It does not appear that this will work because we are not searching for null record fields, but searching for numbers in all fields of a record that are in a list of numbers in a another table.

I have a database with 2 tables and doing a study of certain products shipped. Table1 records are a line detail of SKU's shipped. For example if 1 item shipped then only column1 has data, but if 2 items shipped there is data in couumns 1 and 2. The data is the shipped SKU. Table2 is a SKU...

Thanks everyone for your suggestions. Problem solved. scootswiss

Our company is mail order and receives updates from our drop shippers on orders filled. This information is in an Excel spreadsheet. One of the fields has the FedEx number formatted like this 0300-1290-0006-4640-9750. To upload this information to our mainframe system the field can not...

Malcolm, tried your suggestion. Worked very well. Thank you much for your assistance.

This did work except putting &quot;&quot; returned no data in this column. Changing it to &quot; &quot; put a space between the whole numbers and the decimal. This also worked doing something such as &quot;b&quot;. Any suggestion on how to correct the &quot;&quot; situation?

ToText {FMSH_REQUISITION_DETAIL.COST_EA}, &quot;000000.00000&quot;,5) Above is my formula to convert this Oracle cost field to text. It works, but our mainframe programmers need this field formatted without the decimal. How does this formula need to be written? The Oracle field is a...

I am compiling a report in Crystal 8.0, pulling data from an Oracle database. The flat file will be imported into a mainframe system. My question, is it possible to write a formula for a text field to always be 6 characters, even if the data is only 4 or 5 characters? In other words, use a...