Search results for query: *

here is the SQL from a query i have, this works fine until i have no records to count in one of the programs (e2cipt or modipt or psipt), it just eliminates that program. is there a way i can keep the program and make it come in with a 0(zero). SELECT Count(Input_tbl.Program) AS CountOfProgram...

i have a query that has a program field with criteria for (3) different programs, then i count the number of entries for each of the (3) programs to determine how many items are open for each program, works great until there are no items (null values) then i get no output for whichever program...

i have a table with part number, sometimes the partnumbers are repeated by the engineer with a new revision, i can not just delete the duplicates, when i work in excel or access with the table as you know it only looks at the first number when you are doing a compare, is there a way to make...

i have a system that will kick people off the database using forms, the problem is the form that is open in the backround, it works fine as long as i minimize the form, but when i have it hidden in the backround when i open the second form to set the time for the closing of the database it...

i know you can't have two autonumber fields in access, but can i make a number field that will act like an autonumber, when i add new records i need this second field to go up by one number also, i tried using the max()+1 in the default value but that didn't work.

i am admin on a database that is kept on a server for our company, when the database has problems i have to call the IT people to get them to remove everyone from the database so i can fix the problem. is there a way that i can set something up in the database the will kick everyone off the...

i am trying to write an if statement that will find different occurances and return a result, if Item = like "123A*" then Cat = S end if. this works fine but to save alot of typeing or space i want to use the like for more than one instance if item = like "123A*" or "123AB*" or "123B*" then...

i have a main form that is used for the database, on one of the check boxes i have a procedure that opens a form with some more check boxes, i made the second form off of the same table, i want the second form to update the original table, every time i try this when i try to move to another...

i have my main form using the main query in the database, i have pur a checkbox on the main form that (with code) i have it also opening another form with checkboxes that are also in the main query. when i check the boxes all the checks go to the last record, i want them to stay with the record...