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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by 1koppp

  1. 1koppp

    SubForm class module for SubForm as SubReport

    Hello, I have a subform which i was trying to flag a barcode (field) to be visible if a "Special" box is checked. I used code "special = -1" etc etc. everything works great on the subform if I have the code in the "Current" condition and in the 'Special' "AfterUpdate" condition; However I...
  2. 1koppp

    Max Date on report

    Allright. I have the second query working also. The code I typed from above was giving me a "aggregate" fault. I just created a query through design view and grouped by max. (SQL must have been slightly different). Anyhoo, I have it working and can continue on with my many reports...
  3. 1koppp

    Max Date on report

    GOT IT!. I removed tbl in front of the table name. Sorry, I didn't title my objects like that. OK, so I have the union query working, will make the followup query and let you know how it turns out. Thanks again for your patient assistance, Pete
  4. 1koppp

    Max Date on report

    It is giving me a problem I had before now, (when I tried and END statement): It says it cannot find the table, and to check that it exists and is spelled correctly. It does and it is.
  5. 1koppp

    Max Date on report

    Does that mean to remove the last "union all" and place the ";" after strainreliefdelivery is not null?
  6. 1koppp

    Max Date on report

    OK. Same thing: Incomplete Statement. I tried actually adding another line that said END, which gave me other faults. Here's the SQL: SELECT [WorkRequest#], "BalloonDelivery" as Deliv, BalloonDelivery as DelivDate FROM tblWRSpecialComponents WHERE BalloonDelivery Is Not Null UNION ALL SELECT...
  7. 1koppp

    Max Date on report

    K. I wasn't able to get to this until late today. I got a syntax error. Incomplete statement, I think. (Couldn't save it either). I think it has to do with the # symbol after WorkRequest. Any Ideas?
  8. 1koppp

    Max Date on report

    Allright! Excellent! My problem lies in the fact that I have never normalized data, nor created a union query, NOR ever tried to use SQL. Having read your post, which is most informative, I am now exposed to a whole other section of Access that I have not used . I appreciate your patience and...
  9. 1koppp

    Max Date on report

    Ok. Primary field is WorkRequest# BalnDelivery PrxInDelivery DxInDelivery MBDelivery DXOutDelivery TpDelivery MdshftDelivery MManifoldDelivery B-TubeDelivery OManifoldDelivery StrRelDelivery All (delivery)have input mask:99/99/00;0;_ K. Thanks Again. I guess I need to buy...
  10. 1koppp

    Max Date on report

    OK. I think I understand. BUT I know I will need clarification. Create a query where the delivery dates are listed when they are NOT NULL. (criteria) Where do I put the 'union all' command or code, or whatever we call it? My understanding is we are making a master date value which will then be...
  11. 1koppp

    Max Date on report

    hello again, The actual number of fields is a lot greater than four. The table they are in indicates any special ordered components of a product that is being made from the work request. There are 3 tables tied to the work request number. One is basic work request info which includes type and...
  12. 1koppp

    Max Date on report

    I'm afraid I don't understand. This data is in a select query combined with 2 other tables already. The tables are combined in the query with the relationship being WorkRequest#. Everything I need from the query works for the forms and reports, except my 'maxdate' problem. I have made a column...
  13. 1koppp

    Max Date on report

    OK. Thanks for your response. For each work request generated, I have several dates in columns. These dates are delivery dates for pieces necessary to start making the requested item. [work request]. For easier viewing, I am trying to create a 'maxdate' or 'lastdate' category for each work...
  14. 1koppp

    Max Date on report

    Hi, I am trying to sort a table of work requests with several columns of dates to find the latest date of those listed. I have tried ascending order in the query, but it doesn't really do what I want it to. Ideally this 'maxdate' would then be stored back in the table in another column. The date...
See more

Part and Inventory Search

Back
Top