Search results

I’m retrieving information on members of a case. Each case has one dad, one mom and one or more child(ren). When the query is run I get the information I want but when a case has more than one child the query is generating a full line of information for each additional child. Here is an...

I spoke too soon. That doesn't work. Any suggestions?

I think I found the answer myself--thanks anyway Year([SalesDate]) = Year(Now()) And Month([SalesDate]) = Month(Now()) - 2

This is the query I have: SELECT a.ID_CASE, a.AMT_TXN_CUR_SUP FROM NOLDBA_LOG_SUPPORT a WHERE a.MTH_SUPPORT in (201007, 201008); It returns how much CUR_SUP is owed on each ID_CASE in the past 60 days. The CUR_SUP field is not in days it is in months. So whenever I need to run the query I...

That worked!! Thanks Mike [CSEME_OTHER_PARTIES.OTHER_PARTY_ID] &[CSEME_OTHER_PARTIES.OTHER_PARTY_TYPE] AS PARTYTYPE

I'm still getting the error SELECT CSEME_OTHER_PARTIES.OTHER_PARTY_ID, CSEME_OTHER_PARTIES.OTHER_PARTY_TYPE, CSEME_OTHER_PARTIES.OTHER_PARTY_NAME, CSEME_OTHER_PARTIES.OTHER_PARTY_AKA, CSEME_OTHER_PARTIES.ADDRESS_LINE_1, CSEME_OTHER_PARTIES.ADDRESS_LINE_2...

I've followed the instructions in other posts but can't get my query to work. Can someone tell me what is worng with the query? I'm trying to create a new field called "PARTYTYPE" I'm getting error "Syntax error(missing operator)in query expression PARTYTYPE ...

That was all it was, what a dope I am. THANKS !

I'm trying to get the date difference between two dates recorded in months. Whe I run the query I get a parameter value box asking for CAT 3 SAMPLE CASES 2.RAX RESOLV. If I just click OK results are returned to the new table but the MONTHS field is empty - date difference in months was not...

Too late tonight will look in the moring...but looks pretty good and it might work for me. Thanks for your time!

Report named CURRENT BY CASE Form named NCP/CP AUDIT TBL Sub form named CURRENT BY CASE I want to put a command button on the sub form to preview a report called CURRENT BY CASE But I only want to preview the current record on the form NCP/CP AUDIT TBL, not all the records. The unique key for...

Access 2003 I have Form to summarize information from several other forms into one form using sub forms. Each of the forms is connected to each other by a case number. One of the sub form summarizes information from a table which tracks total $ received by case. That table has all the...

Works, thanks

I'm trying to return only records where the DateDiff is greater than 10. I just can't seem to make it work. Would someone help please. (query shortened to take up less space) Thanks SELECT DISTINCT A.WORKER, A.RUN, A.TODAY, =DateDiff("d", A.RUN, A.TODAY) AS DAYS FROM [3 MATCHED ON NCP...

Namliam Yes I understand Left and Right joins. I figured out a way around the issue which required me to create another table, but that is no big deal. Thanks for all your time. Mike

Namliam That didn't work either. Here is the query with your adjustments SELECT DISTINCT [2 CASES BY DIST AND WORKER DETAIL].CASELOAD, NOLDBA_LOG_SUPPORT.ID_CASE, Sum (NZ (NOLDBA_LOG_SUPPORT.AMT_TXN_CUR_SUP)) AS [CURR PAID] INTO [3 CURRENT PAID] FROM NOLDBA_LOG_SUPPORT LEFT JOIN [2 CASES...

Namliam That didn't work either. Here is the query with your adjustments SELECT DISTINCT [2 CASES BY DIST AND WORKER DETAIL].CASELOAD, NOLDBA_LOG_SUPPORT.ID_CASE, Sum (NZ (NOLDBA_LOG_SUPPORT.AMT_TXN_CUR_SUP)) AS [CURR PAID] INTO [3 CURRENT PAID] FROM NOLDBA_LOG_SUPPORT RIGHT JOIN [2...

The query below shows me the current amount paid for each ID_CASE. The problem is when there is no CURREN PAID the case does not get included in the table [3 CURRENT PAID]. I want the case to show up in the table with the [CURRENT PAID] as $0. Can someone please point me in the right...

Thanks to all I went with GalaxiomAtHome-- "Where [CURR DUE] <> 0"

I have the query below and keep getting "Division by Zero" error when I run it. I'm looking for the percent of CURRENT PAID to the CURRENT DUE. There is one CASELOAD which has "0" CURRENT DUE AND "0" CURRENT PAID and I believe that might be what is causing the problem. Can someone point me in...