Search results

you need to check the data to see if it is there. like field1:iif([data1] is null,0,[data1])*iif([data2] is null,0,[data2]) I am sure there are millions of ways to do it but I seem to do it this way. sam

pono1, I like that idea better than mine. Mine works 99.9% of the time but I did run into a problem where the database that has the table in became corrupt(happened once so far). I could not get into it to log the people out. sam

I have done someting quite differant but somewhat the same. I have a form that loads at startup and automatilly hides. On this form there is a timer that runs every few minutes. I have done it a few differant ways but the jist of it is it checks a record in a linked table to see if it is "yes"...

try this http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=37729 sam

could you do a min in you grouping query. if your yes/no field is set up normaly then -1 would be a yes, 0 would be a no. edit it would then show the yes if there was a yes for that group of numbers - then filter the yeses out sam

with access all of the processing is done on your computer. The network traffic is bad because you computer has to pull the info off the server to run querys and such. Ether way it is this way - split or not split. If you are looking at having the server do the work then you need to get somthing...

I have actually done this. We have a die inventory that need to reuse dienumbers becouse of space problems. say we have 4000 dies. I made a table of sequential numbers(1 to 4000) that I link up with the die table. It is linked up in a query showing all the seq numbers and only the die numbers...

? how do you know when you run the append query to the master table what the key is. I have some uses for this but got stuck at that point. sam

microsoft kb http://support.microsoft.com/default.aspx?scid=kb;en-us;308636 for 97 http://support.microsoft.com/default.aspx?scid=kb;en-us;278379 for 2000 I have not tried it - it looks involved sam