Search results

I have two collums, currentowed and currentpaid. i want to add another field to my report showing the percent of currentpaid to currentowed but I can't seem to be able to make it work. I tried: =sum([currentpaid]/[currentowed]) and it doesn't work. Can someone help me?

Can someone help me convert this sql query so I can use it in access? I have no idea of how to do it. Thanks SELECT a.case_id FROM NOLDBA_INT_CASE_STATUS a, NOLDBA_RPT_CASE_CHG_IND b WHERE b.case_id = a.case_id AND b.sys_curr_date = (SELECT MAX (c.sys_curr_date)...

I'm trying to combine 4 columns. Some of the columns have leading 0's and when I run my query I loose the leading 0's. BATCH SOURCE NO SEQ LINE 11012011 P 0048 005 25 SELECT [BATCH] & "" & [SOURCE] & "" & [NO] & "" & [SEQ] AS RECEIPT...

Trying to create a new column in report to figure the % of collections to the sum of all collections for each district. Please see attachment. Thanks Mike

I have a report based on a query. In the report there are severl columns and I'm trying to figure the % of current paid to current owed. This % is figured on the report itself and not the query. The problem is that there are some records that have $0 current paid and $0 current owed. When...

I had someone experienced in sql (doesn't know Access) to write me this query to give me a count of cases where an EFN31 notice was sent and the date sent was greater than or equal to 4/23/2012. This is the query and it works fine but I would like it in access and I tried it in Access and it...

I’m trying to get the number of cases with an establishment type P and a case type A for each district (DO). The problem is if any district does not have any cases with establishment type P and case type A the query just jumps over that district. It doesn’t list it the district showing it as 0...

I have the query below and I want to remove the first 16 leading characters from NOLDBA_NOTES.DESC_NOTE. Right now for that field the query returns Amount Received:105. 105 is a dollar amount and that is all I want to see. Each record has a different dollar amount. I want to remove AMOUNT...

In my report for each worker I’m trying to figure what the % of current paid to current owed. Some workers have no current paid ($0) or no current owed ($0) or $0 in both fields. When I run the report I get an error “Division by zero”. Could someone please show me how to fix this? See...

I plan on doing a mail merge which will include the case id(s) from the data collected with this query. There are clients who have more than one case id but I only want to send them one letter that lists both cases and I’m not sure how to do that. Is it something I do within this query...

I’m trying to figure out how to come up with the total number of cases in District WW which have an establishment type of P and a case type of A. When I run this query the results are showing as all blank fields in the table. My table has 4 columns, DO, P, A & CASES. I already know that the...

=[PA_CASES]+[PM_CASES]+[PN_CASES]+[PF_CASES] Using the Expression Builder I'm trying to add the numbers across a row. The problem is [PF_CASES] is NULL and it is causing nothing to be caculated (field comming up blank) Some months when I run this report the PF_CASES field will not be null...

I've read several posts and still can figure out where to put Nz([fieldname],0) as somone suggested. I'm not sure if this is even correct. If the record count comes back null I want the query to insert a 0. Here is the query: SELECT PA.DO, NOLDBA_INT_CASE_STATUS.ESTABLISH_TYPE AS P...

I have a table and one of the columns contains the case type, which may be P,A,M,O & X. I would like to change all the X to N. Would someone explain to me how to do this? See screen shot.

I have a report with two sub reports. What I want to do is sum the numbers from each column from each report to get a grand total. I have attached two pictures which will hopefully help someone understand what I'm trying to do.

This query, among other things, returns CASE_TYPE. One of the case types is being returned as “X” which is a valid case type. What I want to do either in this query on in a query based on TABLE 1 ,created here, is to change all CASE_TYPE “X” returned to CASE_TYPE “N”. Could someone please...

I have a form (case information) which has two sub-forms. I want to add a third sub-form. The form and the two sub-forms are linked by an audit id number The third sub-form also contains the audit id number. This form contains the worker names assigned to each case. (Sometimes one and other...

I have this query which I wrote sometime ago in SQL. I would like to convert it for use in Access 2010 and I'm having problems when I try and run it. I'm getting the error shown in the screen shot which is attached. Anyone have a suggestion? Thanks Mike Select...

I'm getting error when I run this query can someone help? Error is Missing ),] or item in query expression A.CD_STATUS_RECEIPT="H" AND A.DT_DISTRIBUTE Is Null AND A.DT_END_VALIDITY=#12/31/9999# AND A.AMT_TO_DISTRIBUTE BETWEEN 100 AND 500 AND Not Exists (Select 1 from NOLDBA_RECEIPT K...

Access 2010 The production DB table has field called DT_AND_TIME_SCHEDULED and the data is stored as: 5/9/2007 1:30:00 PM I can’t change the format of the table field because it is our production DB. So if I’m looking to find any records that are scheduled anytime on 11/15/2011 what would I...