Recent content by takeover

Gurus, I have table called Table1 in MS Access with 10 columns and have a similar table, Table2 in SQL Server. I have created the link table from Access to SQL Server. I need to compare the data in Table1 to that of Table2 and find the duplicates and insert the output to a third table in MS...

Hi Duane, You are so nice and good. Thanks for your patience. I have done it at last with your help. Keep it up. takeover

Thank you somuch for all your help. I identified the problem but no clue how to fix it now. This is the problem. My query which the report is based on is a crosstab query. The output of the base query is like this Id REC_NUM Type Count 100 00 RN 10 100 00 PT...

For your first question:Yes, you are right. The dates in the DoCmd.OpenReport command are the only date fields available in the record source (fields in the design view) I have set the criteria in the query because in the first query only I am refering to the dates which I need to filter out...

Yes, those are two fields in the record source. As I said earlier, these dates are also parameters to the queries too.

DoCmd.OpenReport "rptNumVisPerDiscpl", acViewPreview, , "CERT_FROM_DATE >= #" & strWhere & "# AND CERT_TO_DATE <= #" & strWhere1 & "# "

Hi Duane, Yes, I am using DoCmd and having a where clause in that. That where clause is being used for two other output fields. (The text boxes in the form is actually supplying the parameters for the where clause in the DoCmd.OpenReport and two other parameters in the query itself). When I...

Hi, I am able to run the queries separately now with success, but when I try to open the report from the form, I am getting an error saying Microsoft Jet database Engine does not recognize " as a valid field or expression. What does this mean? takeover

Hi JonFer, Thanks! takeover

Hi, Can I have a total count column also in this query? CUST_ID REC_NUM COUNT1 COUNT2 TOTAL_COUNT 100 00 3 3 6 100 01 2 3 5 101 01 2 3 5 102...

Hi JonFer, Thanks a lot! So nice. takeover

Hi Gurus, I have three tables like below Table1 CUST_ID REC_NUM 100 00 100 01 100 02 101 00 101 02 ----------- ----------- Table2 CUST_ID REC_NUM DATE 100 00 10/10/2002 100 00 10/11/2002 100 00 10/12/2002 100 01...

Hi, The code doesn't work. It says "To set this property, open the form or report in design view. takeover

Hi Richard, That was quick. Thanks a lot! takeover

Hi, My primary key is a key with three columns. How could I code this? takeover