Search results for query: *

I am sorry for not explaining myself very well. All records in both tables are linked to ID field such as A10109. This field may have many rows of data. Here are the fields. ID, Field1, Field2. For example based on Id field, field2 in both tblA and tblB may have the same data where ID=A10109...

I am sorry not to identify the unique. Unique key is the "ID". Here are the fields. ID, Field1, Field2. For example field2 in both tblA and tblB may have the same data like ID=A10109, field2 = A10109Z3.Where thi is found, I want to keep the data in tblA as is and change field2 data in tblB to...

dBforums > PC based Database Applications > Microsoft Access > Compairing tables for duplicate records and increment LinkBack Thread Tools Search this Thread Display Modes #1 (permalink) Today, 00:40 osimini Registered User Join Date: Jun 2008 Posts: 23...

Yes. Thanks very much I solved the problem because I forgat to link the master and child together.

Please I need a help with issue reated to problem I am having with my report to have subreport to pull or report only data related to common providerId in main report. I have Main report called rptFacility with ProviderID identifying a particular facility. Also, I have 2 subreports in the main...

Yes I did. It was set to the query locationID just as below: Control Source: LocationID Row Source: SELECT LocationID, TotalMembers FROM qryLocationTotal Bound Column: 1 Column Count: 2 Column Widths: 0,0.5 Locked: Yes Enabled: No

Thanks for all the help. I used combo box as suggested. Combo box displays nothing on the form, but if clicked drop down button you will see the numbers.

I am still not able to get the TotalMembers number display in the form. I followed the steps that dhookhom suggested yet stll no show. Any suggestion or is there any other way to have this accomplished - How can I display the TotalMember from the query in unbound field of frmLocation once the...

i have a table called tblLocation with LocationID as the primary Key and a query called qryLocationTotal with LocationID and TotalMembers.Both the table and the query has LocationID as linkage. I designed a form called frmLocation with tblLocation as the source table. In frmLocation I added an...

Please can somebody help or direct me on how to solve this problem with duplicate address A suitation where a provider_ID have two addresses in the same address, one with suite number and other without suite number. I want to issolate or remove the duplicate address without suite number. I have...

Please can somebody help or direct me on how to solve this problem with duplicate address A suitation where a provider_ID have two addresses in the same address, one with suite number and other without suite number. I want to issolate or remove the duplicate address without suite number. I have...

Please can some help to direct or point me to on how to solve this problem. This is probably a simple problem but some how i am lost. Pasted below are two tables. Table 1 is now the data is now and table 2 is the expected result. I want to group the fields T_Code and G_code by ID. All to be in...

Please can someone help or guide me to resolve this problem. I have an access DB called "Monthyly.accdb". Monthly.accdb resides in the directory "\\Camp\public\Provider Network Relations\". I do not want to be going to the user work place desktop to install the application any time there is a...

lET ME USE THIS OPPORTUNITY TO THANK EACH AND EVERY ONE OF YOU FOR YOUR HELP.dhookom, I used your method or suggestion and it worked. Againt thank you all.

Thank you for all your help. "ACTUALLY, I WANT TO COMPARE FIELD VALUES IN THE TABLE. FOR EXAMPLE, LAST_NANE (TABLE B) AGAINST LAST_NAME (TABLE A). But nt comparing the tables structure. can some please help. I

I want to use VBA to compare two tables and write out the field where there is no match. "Table A" is the main table and "Table B" is the varying table. Meaning to compare "Table B - fields" against "Table A - fields" to produce no match report. The reason that I want to use vba is because it is...

Please I need your help. Will it be possible to run multiple qction queries from a single button. For example: from open query -> make query -> query to group or sum data -> Report. I will appreciate any suggestion or help. Thanks

Here is the RowSources of the three combo boxes. frmCases Row Source: SELECT tlkpEmployees.EmployeeID, tlkpEmployees.EmployeeName, tlkpEmployees.EmployeeFirst, tlkpEmployees.EmployeeLast FROM tlkpEmployees; fsubCasesEvents Row Source: SELECT DISTINCT tblCases.CaseOwnerID...

Thank you very much OK Here is maore explanation. Both fsubCases and fsubReminder are subforms to frmCases which is the main form. 1) All three forms are linked by as follows. frmCases.CasesID = fsubCasesEvent.CaseID. frmCasesCaseID = fsubReminder.CaseID 2. frmCases is an independent form...

Headache I have been trying for 2 weeks now to to get this to work no success. I have tables for E, Cases, CaseEvents, Customers and Reminder. I have created a form frmCustomer as mainform.Then another form frmCases. Also created two sub forms called: sfrmCasesEvents, fsubReminder...