Search results for query: *

We have an app that holds lots of records - the record tells the app what report to run at what time. So, it looks like this: Report Run Time ------------------- A 9:15 B 9:35 C 10:45 D 9:16 E 8:12 A 20:15 B 21:15 A 7:00 D 8:00 F...

I have a form with the following fields: Beginning Balance, Additions, Subtractions, and Ending Balance. Additions and Subtractions comes from a query, Beginning and Ending balance are derived (Beginning Balance on the first record comes from a table). Ending Balance is just calculated...

I wrote my first pass-through query and it has several nested select statements. When I run the query, a window pops up asking me to pick the data source and I have to choose the appropriate ODBC connection. This box pops up 4 times in processing my query (I'm assuming due to the nested select...

Sorry, I know this is the most basic question and I've spent hours searching. I must just be using the wrong search criteria or the explanations are over my head. I have a value in a one-row table that I divide by the number of days in the current month. I need this value often for other...

I have a query with a running total that sums up a bunch of credit card/bank accounts. This the result set I need: Account - Closing Date - Balance - Running Total ------------------------------------------------- Bus Acct - ??? - $400 - $400 VISA 1000 - 08/15/2007 - ($1500) - ($1100) VISA...

I wrote a query to show orders and their due dates using a ODBC link to our orders database (the db is sql server if it matters). We're not able to write back to the database (or just really don't want; we would hate to screw something up). One guy who handles the orders would like to have an...

I've been advised that I should purchase a laser barcode scanner with a USB plug. Does anyone have any recommendations? I'm only familiar with the WASP ones and theirs is $300.00. Just thought I would ask before I shell out that kind of money. Kelly

I'm a total XML/XSL newbie and just can read a little bit. I have a shipping application where we can write templates in XSL, so I'm having to learn it. I have a field in the application where we type comments like: Customer needs the following items: 1 Red Shirt 2 Blue Socks 7 Green Bags...

I have a very simple Flash tool that was written over a year ago (not by me). I want to make two simple changes to it, but I have no idea what I'm doing. When the tool loads, I have 5 input fields (one text field and 4 comboboxes). How do I set default values for these fields? For example, I...

Total newbie here. I'm working with a field in a shipping program that comes in pounds (i.e., 2.75 pounds) that I need to convert to two form fields: pounds and ounces For pounds, I would need the value to be 2 For ounces, I would need the value to be 12 I am XSL stupid. Any help would be...

I know how to write a basic query to find the oldest order (based on order date). How would I write a query to find the oldest 5?

I have a "lookup" table setup so that inventory coming in will be classed in one of three buckets. The inventory title is the value being referenced and it has lots of crazy values. Samples of titles in the "Data" table are: "Widget XL" "Widget Small" "Widget Medium! Special! Free Shipping!"...

Hopefully, I'm saying all of this right. . .I don't know much about this code at all. We have a small shipping program where we can write custom invoices in XSLT (I thought it was XSLT, but maybe just XSL). I have a field that is pulled in at the end of the invoice: Order Notes. This will...

I need to create a Flash program with a text box, a box for a number and a print buttom. When the user enters a letter in the text box and the number 20 and hits print, the letter will print 20 inches tall to paper. I realize paper isn't 20 inches tall, so I would want the number to spill over...

I have 3 tables: Orders Shipments Reporting Shipments holds shipping cost (there can be multiple records per order since there can be multiple shipments per order). Primary key is Shipping ID. Orders holds Shipping ID and Order ID. Reporting holds Order ID. I need to update the Reporting...