Search results

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))")

This is the Dlookup with the DateSerial in it but it comes up with an Error =DLookUp("[Net Insured Charges]","[CashFlow Link]","[RCNAME]=" & "'" & [RCNAME] & "'" & " And [Date1]= DateSerial(Year([CashFlow Link].Date1),Month([CashFlow Link].Date1)-1,0))")

I have tried to use the DateSerial instead of the Dateadd and it still is blank

I am thinking it may be the date1, When I try to pull the data by just a single date it comes up blank but if I use the excel serial number for the date the data appears. Anyway around this

Still coming up blank

Thank you for the reply, the report is still coming up blank for the previous Net Insured