Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gbrigman

    Date Criteria

    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).
  2. gbrigman

    Date Range

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

    Multiple Column Date Report

    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?
  4. gbrigman

    Convert Basic to VB

    Almost every line in the bas file causes an "invalid outside procedure" error. Below is an example: START: Open "COM1:9600,N,8,1,CS50000,DS50000,TB2048,RB2048" For Random As #1 MAIN: Cls Color 7, 9 'the first section of this program...
  5. gbrigman

    Convert Basic to VB

    ttt
  6. gbrigman

    Convert Basic to VB

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

    Append Table Please Help

    Any help on this would be greatly appreciated.
  8. gbrigman

    strange problem in access. urgent!!

    Aren't you getting the dual date prompt because of the fact that the between statement is for 2 different fields?
  9. gbrigman

    Append Table Please Help

    I tried your suggestion. It just gives me the number of bundles. What I need is to get it to run the query x times where x=the number of bundles, appending the table each time it runs.
  10. gbrigman

    Append Table Please Help

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

    Calculation using field in linked table

    Is it impossible to do this calculation the way that I need to?
  12. gbrigman

    Calculation using field in linked table

    First, let me say sorry for being such a newbie. SQL connection to dbo_jomast, dbo_joitem, and dbo_inmast SELECT DISTINCTROW dbo_jomast.fjobno, dbo_joitem.fpartno, dbo_joitem.fmqty, dbo_inmast.fnusrcur1 FROM (dbo_inmast INNER JOIN dbo_jomast ON (dbo_inmast.frev = dbo_jomast.fpartrev) AND...
  13. gbrigman

    Calculation using field in linked table

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

Part and Inventory Search

Back
Top