Search results

But if I remove "qryforSOPMT005F1Filter" like you suggest then I am getting all the records in one report that's why I used qryforSOPMT005F1Filter. Can you show me how you could make it work without qryforSOPMT005F1Filter Thanks RB

JHB, Attached is a copy of the database. So you see what I am talking about. go for example to NCR 16-0155 and click on the "Print/Email SOP MT005.F1" Hope it make sense now. Thanks for looking into it RB

JHB, I have attached a copy of the report I get now. All I need is the first 2 pages but the pages keep repeating as you can see. What do I need to add to the query or report to stop that Thank you RB

Hi, I have been trying to make this work for 3 days and hasn't been successful. I have a form and a subform and within the subform I have a button that allow the user to create a report. The report also has a subreport. All works great when the subform which in turn the subreport have one...

Hi, I have created a database to track the training competency matrix. The way I did it is using the crosstab query. The database is working fine but I spend a lot of time doing manual stuff for the report as my column numbers change. Let me explain. I have lets say 10 manufacturing areas...

I used the same approach to capture the documents along with their appropriate revision. tblDocs (strDocNum (PK), strProcName, strProcNum, dtmObsDate) tblDocRev (strDocNum, strProcRev, dtmRevDate) The above table feeds a form and a subform (frmDocument and frmDocRev). All works well...

Plog, Thank you, I got it to work as you suggested. With that resolved I can continue with the rest of the forms I need

plog, I followed your recommendation and re-did my tables as below. What do I need to do to retain the information in tblemployeesAssignment. I need to keep all records of an individual as they move through different areas of the organization. Right now using my form "frmEmployeeAssignment"...

plog, My form is linked to tblemployees. This what I have so far: tblemployees. - strEmpNum (Primary Key) - strLastName - strDpt - dtmHireDate - dtmInactiveDate - dtmTransferDate tblemployeesTransfer - strEmpNum - strLastName - strDpt - dtmTransferDate Right now I have...

Hi MarkK, I just wanted to retain the employee's training information and that's why I created the other table in order to capture what departments/areas the employee had been from the date of hire. How do I add a transfer table structure can you tell me more. Is that an update query or...

Thank you for the prompt response plog. The field names I provided was just an example. The actual field names are as follows - strEmpNum (primary Key) - strLastName - strDpt - dtmHireDate - dtmInactiveDate -dtmTransferDate I read and try what you are suggesting

Hey, I am working on a database and one of the tables is tblemployee which had the following fields - Name - Department - Date of Hire - Date of Transfer - Date Inactive Also I have tblemployeeArchive which have the following fields - Name - Department - Date of Hire - Date of...

I gave up on the query thing as I cant get the results I want so another idea I had was using vba to go into the table with duplicates and compare the fields in columns A and B from one row ro the other and delete the duplicate row and keep going till end of table. Any wrote a vba to do that...

Oh I see, I already tried that and I still get the same result

Sanzoo, I dont follow what you are saying. currently the result that I shared in the example is from a query. I need to know what to do to the query so I can get something like this A B John Doe Tires John Doe Wipers Allison Doe Tires

Hi, I been trying to come up with ideas but so far non is giving me the outpu I want. I am trying to create a query to find duplicates and delete the duplicates. The result will eventually be used in another query (append query) to update a table. So let me shed more light on what I am...

CJ_London, I will try what you provided. I fixed by changing the Memo field to a Text field. I didnt want to duplicate the fields in tblRecords if strProcNum and strProcRev and strProcName in tblRecords are equal to strProcNum and strProcRev and strProcName in qryNewtblRequired but if...

CJ_London, the database is attached in post#7. I just downloaded it and unzipped the file. Its in 2003 format. Let me know if you having issue and I will try to load it without zipping it

CJ_London, I will try what you have posted. I have attached my test database with sample data to give a better understanding of what I have. So basically each time I run "qrytblRecordsNew", tblRecords gets appended with all the data regardless if they are there.

Below is what my current append query looks like. Each time I run it just adds to tblRecords even if they exist INSERT INTO tblRecords ( field1, field2, field3, field4, field5) SELECT DISTINCT tblEmployees.field1, tblEmployees.field2, qryNewtblRequired.field3, qryNewtblRequired.field4...