Search results

I have a report that looks up a previous date then finds the data that goes with that date. I went to run the report and the data now is blank. I am thinking it is because of the formula is looking for 1/28/2013 instead of 1/31/2013. Can come one help with this. Here is the formula...

I created a report that uses a text box that has the following formula in it ="Office/OutPatient (" & [Catagory] & ")" This formula worked until I added a subreport. The subreport uses the same but with a slight difference="Office/OutPatient (" & [Cat] & ")". How do I get rid of the error so...

I created a query that pulls information from 2 other queries and everything was going fine until I saved the query. I now get a circular reference error Here is the query. Any help would be appreciated SELECT [CashValue Link Query1].Facility, [CashValue Link Query1].[Financial Class]...

I currently have query that looks at 2 tables that hold financial information. I am querying the data to do some adding and subracting based off a financial class of a facility. The issue I am having is that one table may have a financial code that the other does not have but I still need to...

I am trying to write a query that is dealing with alphanumeric and I am stuck. I have a table that has a client#, Date of service, CPT_Code and amount. The CPT_Code can contain numeric and alphanumeric. What I trying to do is define the code using a case when statement. Example Case when...

I need to pull the previous months record and I keep getting blank for the dlookup. The Date is set up to be th last day of each month. Here is the dlookup I am trying to use =DLookUp("[Net Insured]","[CashFlow Link]","[RCNAME]=" & "'" & [RCNAME] & "'" & " And [Date1]=" & "#" &...

I been trying to get a query written that will pull the previous months total for a facility so i can subtract it from the current month to get a change from the previous month to current month. Here is my current query that I am stuck on SELECT [CashFlow Link].LOCATION, [CashFlow...