Search results

I am trying to compare tables and it is comparing within the table in addition to the NEW and the OLD table. For example, a family is listed in the tables like this: NEW table subsc_num last_name 123456789 hubert 123456789 hubert 123456789 smith OLD table subsc_num last_name...

I am trying to update Table A PCP field with Table B PCP field when the zip field in both Table A and B match. Is an update query the best way to do this? If so, please give me an idea on how to do this. Thanks.

Hello, Something strange is going on with a query I have. I have a command button on a form that pulls from a query "RejectPercentTPSummary2". When I run the query through the form (command button) it brings up an error box stating "You cancelled the previous operation." But when I run the...

Hello, I have a form which contains fields populated by a query when the form opens. The fields can be modified by a user (change the data in the field or fill in a field). I have been asked if it is possible to track the field changes. For example, if the user changes the date field, stamp a...

I am having trouble identifying duplicates. When I run the query below. I get duplicates including the original record. How could I modify this to get just the true dups? For example, record 1 has duplicates record 2 and 3. I only want record 2 and 3 to show in this query. Please help. Thanks...

database error - urgent When I try to open the database it brings up my startup form but when I try to view the tablesthrough the database window I get an error message "Operation invalid without a current index" When I try to view others...queries,forms I get this other error message "...

I need to convert a column that was originally set as a text datatype for numbers. Well now that I need the data for the queries. I need to use it as a number datatype. Because the table contains 417,000 records I can't convert it by changing the datatype due to memory space. Also, I have tried...

I have this query that is pulling incorrect data. For example, My Start Date is 06/24/02 and my End Date is 06/24/02. When I run this, it pulls 06/25/02 also. Is this query wrong? SELECT DISTINCTROW INDIV_TP_SUB.CHILD_TP AS TP, INDIV_TP_SUB.SCRUB_DATE AS [Scrub Date], Count(pend_list.CLAIM_NO)...

Is there a way to include the date parameters in the query output? Here is my query: SELECT DISTINCTROW INDIV_TP_SUB.CHILD_TP AS TP, INDIV_TP_SUB.SCRUB_DATE AS [Scrub Date], rejected_scrubReport.REJ_CODE AS [Reject Code], Count(rejected_scrubReport.MEMBER_NO) AS [Reject Count] FROM...

This is really starting to irritate me.=) I am trying to create a query that pulls specific dates and a specific percentage for the totals. When I try to specify a percentage, for example, I want 6% and above to show only, I get output with % under 6 and a few over 6% but not all the records...

What is the easiest way to close a previous form when opening a new form? I have tried macro and coding and both do not work for me. In the macro I first close the form then open the new form. Why doesn't this work? In coding/modules, this is my code: Private Sub Check16_GotFocus() On Error...

I have a table that contains duplicate values. I want to count one instance of each. For example, the table pend_list has claim_no field with data: claim_no 2215176239 2215176239 2215176240 2215176241 2215176245 2215176247 2215176247 The count of the claim_no should be 5 but I keep on getting...

I have two tables indiv_tp_sub and pend_summary. The fields on indiv_tp_sub are:scrub_date,child_tp,claim_sub. The fields on pend_summary are:tp_num,total,scrub_date. Scrub_date are the same on both tables. Also, tp_num on pend_summary and child_tp on indiv_tp_sub are the same. The below query...

I think my problem is the way they are linked but am not sure. My query does not combine the same tp and date totals. For example, Scrub_date is 6/24/02 and tp_num is RHA. This date and tp is listed twice with different totals, 300 and 1. I want it to combine these as one. So it would show one...

Hello, I am trying to run a query that pulls specific percentages calculated in the same query. When I try to query anything above 1 percent it does not pull the right data. Below is the query. Also, the appended table is set as text ( I have tried different settings but this one seems to work...

I am trying to subtract the date in one field to get another date in another field. For example, the date in ADJ_DATE field is 20020718, I want the SCRUB_DATE field to be ADJ_DATE-1, 20020717. Why doesn't this query work? SELECT pend_summary.RPT_DATE, pend_summary.ADJ_DATE...

I am trying to subtract the date in one field to get another date in another field. For example, the date in ADJ_DATE field is 20020718, I want the SCRUB_DATE field to be ADJ_DATE-1, 20020717. Why doesn't this query work? SELECT pend_summary.RPT_DATE, pend_summary.ADJ_DATE...

I have tried to create a query that shows the last date entered in the table. My table is indiv_tp_sub. The fields are SCRUB_DATE,CHILD_TP,CLAIM_SUB. The table has data entered in weekly, usually. So the scrub date would show for example, 7/10/02, 7/15/02,7/17/02,7/18/02. Based on this example...

I need help trying to run this query: SELECT DISTINCTROW pend_summary.TP_NUM AS TP, Sum(pend_summary.TOTAL) AS Pended, Sum(edi_current.ACCEPTED) AS Accept, Sum(pend_summary.[total])/Sum(edi_current.[accepted]) AS [Pend %] FROM edi_current, [trading partners] INNER JOIN pend_summary ON [trading...