Search results for query: *

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

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

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

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.

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

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

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?

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

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

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

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

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

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

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