Recent content by JMG

If I understand -- you want to see what has been scheduled and completed between dates. Just put your criteria on the scheduled field and if it is completed it will have a date in the completed field. If it is still open it will be blank. Sorry for the delay in posting - wild at work.

If I understand what you are doing--you are putting a criteria on both fields--this may be the problem.

In the query grid (design view) in the 'criteria' line in the field name for "student id" add (without the quotes)"[Enter Student ID]" When the query is run there will be a message box that says "Enter Student ID" with a blank area for the entry.

add another command button on the form with the explanation that if the data is not on this list "go here" the button opens another form where info is not limited to the list you can even have another combo box on the same form to do the same thing.

You can use the same thing in a query. If you do not use the nz() function, you won't be able to do any math on items that have even one null month, ie. if jan, feb, mar have data and apr does not, you cannot add jan+feb+mar+apr. you will get a null answer (if you even get an answer). Access...

In your report, the field that has no data, [ =NZ([yourfieldname],0) ] no brackets of course

Look up CINT expression converts a string to integer

Correct, Namliam, my above post assumes joins have been made. thanks for this correction. edit: Scott, do you understand about the joins? Since I'm not so good with SQL, I start out by using the query wizard with a standard select query, getting the joins and field names as close as possible...

union queries must end up with the same field names in each table select statement. Instead of just the NULL at the end of your first select statement, you should put 'Null as Date Info Received' (you might have to use brackets around your field name because of the spaces in the field name...

If I understand your question--you can add a field from one table that is not in the other table. In your SQL, the tables that do not have the field, use "null as [date info received]".

Place your last Iif statement after the last comma (before the "else" part of the code) - make sure you put a comma behind it before the "else". place a closing ")" and you've got it

check here http://www.access-programmers.co.uk/forums/showthread.php?t=71650

Thanks very much for responding.. I have resolved the problem by-- 1. union query pulling 4 tables together (this gave me up to 4 records for each sku / week. 2. select query (using the union query) and using WIP:sum(Iif([x]="wip",[units],0)) OnHand:sum(Iif([x]="on hand",[units],0))...

thanks, GBlack, but union query gives me too many records. The goal is to have one record per size/per week. thanks for your response.

there is also a "find duplicates" in the query wizard