Recent content by Gootz11

The reason i have 18 databases is that i have 18 different divisions in my company that function independently. They use the same version of the database but have a unique system for themselves,(since they all have different inventory) it would have been imposible to have them all in one...

How do I run queries from another database? or maybe there is a better way to do this. here's what i am trying to do. I have one database that uses data from 18 databases, I need to run a querie which updates the data in each of this 18 databases. I would like to create a command that would...

Hello everyone, I have the following IIF statement in a querie and in returns an error for ever record. REC: IIf([count1diff]>=[trigger],"YES",IIf([count1diff]<[trigger],"NO")) any idea of what i am doing wrong??? Thanks in advance for the help! JG

Is there a way to have the database default a field to a value above it? example Field 1 Field2 Field3 __0001 ABCD Jay __0002 EFGH Jay __0003 IJKL _____ I would want my record in field 3 to look at...

Hello, I have a query with an ID field as well as 35 other colums. I need to write a statement that by ID will give me the MAX record from this 35 Colums. Please Help Thank J

is there a way to perform compact and repair by using a command button and not having to go through tools? please help! Thanks JG

is there a way to perform compact and repair by using a command button and not having to go through tools? please help! Thanks JG

Yeah, i tried the parameter statement but it didn't work. any other ideas??? Thanks

Hello, I currently have a query that randomly selects 100 records from a table. My SQL statement looks like this: SELECT TOP 100 * FROM [X1A Pick Slots] ORDER BY Rnd(asc([slot])); I'm trying to change my statement so that i can enter the number of records i want to select every time i run the...

Hello All, I have a table that gets imported daily into my database which has 3 different quantity fields. (qty1, qty2, qty3) most of the time my qty2 and qty3 fields are blank which prevents me from getting a total qty when i run a query that adds the three. I have the default value set at...

I know this statement is completely messed up but its all i have for now, i tried changing things all over but still can't get it to work DELETE PICK.WHSE, PICK.POH, PICK.Pick, PICK.RESOH, PICK.RESERVE, PICK.TOTOH, PICK.TotalOH, PICK.RPK, PICK.PACK, PICK.CAP, PICK.REQ, PICK.PREV, PICK.SLOT...

I had already tried doing that but get an error meassage that states "specify the table containing the records you want to delete" I tried to run the query several different ways but keep getting the same error. It doesn't seem to recognize 2 tables when you try to run a delete query.

the best thing you can do is have the courses listed as column headings and not rows. so your table would look like this student_____class_____His101___His102____His103 J Smith______J1135______A_______B_________A__ doing this will allow you to show all records for that student in a single...

Turn your query into a make table query. This will allow you to input as much data as you want into it and query against the results. If this is going to be a table that is updated often from the other 2 tables (which you currently have) your best bet is to create an append query that will...

I am currently running a query that selects 87 random records from a table, I want to run a delete query that takes those 87 records that came out in that query and deletes them from the original table so that they can't be selected again until the table is downloaded again... any ideas??? Thanks J