Search results

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]=" & "#" &...

It is a table. I checked for duplicates and I could not find any. Thank you for your help though. I will see what I can do from here

It is now back to duplicates for each facility

I had to attach the error as a pic. SELECT DISTINCT [CashFlow Link].LOCATION, [CashFlow Link].RCNAME, [CashFlow Link].Date1, [CashFlow Link].VISITS, [CashFlow Link].TOTCHG, [CashFlow Link].PAYMNT, [CashFlow Link].TOTCRD, [CashFlow Link].TOTAR, [CashFlow Link].PENCRD, [CashFlow...

Same synatx error but now the date looks like #11/30/2012#

This is the statement I am using. dlookup("PENCRD","[CashFlow Link]","RCNAME = '" & RCNAME & "' and [Date1] < " & [Date1])

I noticed that my dlookup left off & [Date1]) for some reason. I added it in and now I am getting a Syntax error(missing Operator) in query expression [RCNAME] = Bluefield and CLTFAC <> '' and Date1 < 11/30/2012

It displays only upto the previous month. The dlookup gave repeated numbers Here is what it gave CashFlow Previous 130.7 130.7 130.7 130.7 130.7 130.7

Thank you for your suggestions CJ but neither of them worked, I got duplicate numbers. I am not sure if a sub query is the way to go, so i am up for any other suggestions. I am unfamiliar with Access so I apologize.

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