Search results for query: *

I have a database that has several date fields, Order Date, Req Date, and Canx Date. If the Canx Date is left blank, it automatically fills in 1/1/1900. I want to create criteria in a query that says if (canx date="1/1/1900",req date, canx date).

I am currently using between [Enter Start Date] and [Enter End Date] as criteria on a query. This makes it ask for the start date and end date. The problem is, this is a base query for 4 different queries for 4 different dates. What I actually need is "last month" (September, not...

I have a query that runs against several tables and return all records for a date range. I need a report that has this information on it for 4 different date ranges. Last Month Year to Date Last Year Last Month Last Year Year to Date Is this possible?

We have some labels that we print out on an old DOS computer using a .bat to call a .bas file. It prints directly to the printer port (com 1) on the printer. Is there any way to convert these to VB so that I can update the computer to W2K or XP?

I tried to post this in the past. I probably wasn't clear enough. I'll try again. Here's the setup. TABLE A INMAST FPARTNO FBSIZE 100 10 101 20 102 20 TABLE B JOBS JOBNO FPARTNO FMAKE 25 100 20 26 102 40 27 101 100 28 103 10 TABLE C TICKETS JOBNO TICKETNO FQTY 25...

I make belts. Belts are made in bundles of 20. An order is placed for 400 belts. I need to generate bundle tickets(autonumber) for each bundle. The bundle size information comes from linked table 2. The Job number comes from linked table 1. How do I create a query that will autonumber from...