Recent content by jband

Nevermind I figured it out. Just had to think about it a little. Thanks you

But what if I want to go back 2 months

In short yes

Sorry I should of been more clear. The date that I have in my data set is already put in the last day of the month. Example January date is 1/31/2014, February is 2/28/2014 and so on. The issue I am having is when I use Date1 field in a Dlookup to find the previous month it won't do it for...

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

That worked. It pulled in the catagory corectly in both the main report and the sub report. Thank you

I get #Error and #Type! The [Catagory] is located in main report in detail section and [Cat] is located in the same section in the subreport

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 Figured it out. I did the relationship wrong between the 2 tables. Must of been a brain fart on my end.:banghead:

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

Awesome it worked. It was amazing to see it work. Thank you.

SQL I need set the definition to Codes so I can then show the amount to each cataogory (Debit, Charge, etc..)

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 figured out the answer. The dates were not matching up. Here is what i came up with and it works. DLookUp("[Net Insured]","[CashFlow Link]","[RCNAME]=" & "'" & [RCNAME] & "'" & " And [Date1]= DateAdd('m',-1,DateSerial(Year(Date()),Month(Date())-0,0))")