Recent content by cvaccess

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...

Update query I did analyze my data. There was a match of zip field 04101 on both tables. Now I want to update the pcp field in Table A with the pcp field it matched in Table B. Thanks.

update query Well, the match needs to be based off of zip. For example, if zip 04101 in Table A is found in Table B then update the pcp field from Table B to Table A. Hope this makes sense. How could I do this? Thanks.

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...

How does it work? It looks like it trails it to a new table tblAudit but I have tried updating/modifying and I do not see a trail (new tbl). Please explain. Thanks. Function WriteAudit(frm As Form, lngID As Long) On Error GoTo err_WriteAudit Dim ctlC As Control Dim db As Database...

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...

Can anyone help with this? Basically, I need to find a way to leave one copy of each duplicate. Currently, I get all records for duplicates. So when I run a delete query it does not delete all duplicate records...it leaves one copy of each duplicate (the original record). Please help anyone...

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 "...

That didn't work because of the volume. I ended up creating an append query to a new table with the changes and then renaming it. Thanks for your input.

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...

What is your email address?

Nope, that didn't work. I have another similar query that does work so I made it the same parantheses but this does not work still. (bad one) SELECT DISTINCTROW INDIV_TP_SUB.CHILD_TP AS TP, INDIV_TP_SUB.SCRUB_DATE AS [Scrub Date], Count(pend_list.CLAIM_NO) AS [Pended Total], [Enter Start Date:]...

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)...