Search results

I have a problem with a shortage report i made. I have a item header and footer in this report that the report sorts by. The report is supposed to tell me the jobs that are short the item i am sorting by which it does. But i also want the report to tell me all the purchase orders that are out...

i have a running total for a group in my detail section of my report. I would like to be able to hide those records that the running total is equal to a field in the detail section. for instance if the total of my issue qty equals my required qty i dont want it to show on my report can that be...

I am making a shortage report for my work. The problem I am having is i have a work order a part number associated with the work order, a required quantity and a issued quantitiy. Sometimes the inventory person issues some of that part one day and the rest the other giving me two records of...

Pat i'm very sorry i was replying to the first answer. It worked great once I applied what the first person said to what you said. Thanks alot guys you are all a great help.

all that seems to do is put them in order am i doing something wrong? I click on the total button and then i click on max. I tried last but that didn't work either. Please help

I have a query i want to run on a table. I have a table that stores time worked on a certain operation of a work order. What I want to do is have my query give me the last operation that job was at by getting the latest time . How do I have my query give me only the record of that job where...

it didn't work. good try though do you have any other suggestions?

it didn't work. good try though do you have any other suggestions?

I have a query i want to run on the fly from a button. what it is supposed to do is grab whatever value is in the field at the time and put it in the query. I seem to have a problem though. access is telling me that the query does not understand the path i am giving it to get to the text box...

how do i search for everything in my column that starts with 17p in SQL? i tried '17p*' and it didn't work.

i have a problem i have a database where i have 100,000 records. i want to be a ble to query one field in the table. i only want to see the data in that field that is original from anyother data in the field. for instance if the word "bend" is in the field 5,000 times i only want to see it...

i just found my problem but i dont know how to fix it. i want to have the code say gotorecord where primary field = varialble. can anyone help.

I have a refresh button with this code in it. Dim key As String Dim stDocName As String key = Me!primary stDocName = "filter" DoCmd.RunMacro stDocName DoCmd.GoToRecord acDataForm, "certifications", acGoTo, key the purpose of it was to put the record number in...

i posted this in the forms section by mistake as well.sorry. anyways i have a large sql select statement that is longer than one line. everytime i try to bring part of it over to another line by using the _ i get an error. what do i need to use to seperate this statement?please help

Hi I have a problem. I have a sql statement in code that is longer than the line. everytime i try to use the underscore to continue on the next line i get an error. I think it has to do with the whole statement bieng in one long quote"". is there another way to do this. please help

i just removed all the data in this database and tried it and it did the same thing. it seems that as long as i have referential integrety turned off it works fine. i am flustered. what i have is three tables 1 main one with a primary key and 2 others with a number field(not primary key)...

thank you very much

thank you very much

i have a program where i am appending records by clicking on a button. when i do that access gives me messages asking me if i really want to do this. Is there a way to get rid of these messages in code?

i got it to work but i had to remove enforce referential integrety from the relationships of my tables and now sorting through records is very slow. any ideas?