Search results

@gblack Ive tried establishing relationships and have had no change in the results in how this thing runs. Im needing to reference the same field from each table, so Ive assumed an inner join would work but hasnt? I have no clue where to go from here???

@ gblack thanks for the help. Ill read up on that. The tables are all set up for seperate areas of the facility I work at. Ill look into consolidating and possibly using a query to seperate the data I need? Is this the best route to take, or should I do something else?

heres a copy. the query that isnt working is "Completion Query". Again Im not an access guru or anything, Ive self taught myself as Ive went whiling building this database. Its my first one, so Im sure there are some things I could have done differently. Thanks in advance for the help

it for work

Nothing??? Im kinda on a time crunch with this one. Any help would be greatly appreciated

dont have the code. Im not familiar with code writing, its all been done through wizards. The query is referencing 20+ tables which are fed by MAKE TABLE queries. The MAKE TABLE queries are run through a macro. This part is working as expected. But when I hit "RUN" on my make table query that...

I have a make table query that is referencing many tables. When I hit run, it acts like its running but never stops, throws an error code, or creates a table. Any suggestions? Ive tried changing it to a simple query as well and get the same results.

So Ive eliminated all of the unnecessary queries, and added the completion percentage to each query. Now I have 1 query for all audits. The problem Im having now is how do I get the [Completion Percent] from each query to either populate back in the "Index Table" or put into a separate new...

You are absolutely correct on both accounts! Let me see what I can do. one question, how do you get a table to pull data from another table? With the multipliers table I would need it to pull data from "Index" right?

Ok the field names are pretty easy to interpret on my end for me or whoever follows but I see you point. They are actually just the label descriptions from the forms for each field. So anybody on my end that will follow me will be able to reference the forms and know exactly which field is what...

Also just curious, when you say "undocumented" what are you referring to? again im so green to access its not even funny!!! I know almost nothing when it comes to the lingo!

Plog: Everything is working as needed up to this point, to be honest I'm not sure if I've created everything in the right order, or in the correct manner. Again I've self taught myself everything to this point, and have far exceeded the level of anybody else at my location. Needless to say I'm...

here you go guys. the query im having an issue with is Stock Prep Completion

I have a seperate query for each month. Which references a column in the original query name "Month". one of the required fields in the form is a combo box with months listed so it has to be entered.

zipped database and tried to upload but it wouldnt let me because its too large of a file.

Here is an example of the expression im using in the "field name", in this particular instance there are 6 machines so I have 6 columns with same expression just different #. BEC 105: Max(IIf([BEC's Feb Completion Query]![Machine #]="BEC 105",[BEC's Feb Completion Query]![Completed...

If I enter a record in all of the 13 referenced queries it will work as intended. It only doesn't work if there is a "NULL" value in any one of the referenced queries.

Ive tried a LEFT JOIN already and it did not yield any different results. The first queries are referencing my INDEX table which are fed from the data entered on the forms. All of this works correctly. With the new query which is referencing the first 13 queries will on display the records if...

Ok so first off Im extremely new to access. Everything I know I've taught myself. I know nothing about code, SQL, or anything else of this nature. I know very little of the lingo so Im praying that I can interpret the responses, as well as communicate the problem without too much headache to you...

My name is Tony Ellison. Im as green as they get with access. Everything I know has been self taught (which isnt very much). Im building an insanely complex database for my first one (well in my eyes at least)! I live in Ardmore, Oklahoma. A lil about me, well Im a Quality Technician for...