Search results

The error on the report is #Error. What do you mean change the name on the text box to something other than SSN?

It is obvious and the SSN is in the record source. I have attached it to show you.

I have attached what I am doing and maybe you can tell what is wrong and why it's not working. I know it is the best image but if you squint you can see it. thanks Craig

I put that in the record source of SSN exactly how you wrote it. Is that 'me!' the report name or the query name or is it just suppose to be how you wrote it? I did it as you wrote it and as SSN = Right(me!SSN,4) neither seems to work. Sorry I am new at this. your help is greatly appreciated.

I have the same question. I am trying to do it with an SSN = 9 digits and I only want the last 4 digits on the report, but i don't know how to build it in expression builder.

No Offense taken Mailman. I understand what you are saying but can't figure out how to do it. Yes Tables 1- 48 have the same data fields, But how do i capture and hold 48 separate claims with 48 separate dates, 48 separate audits, 48 saperate prevals and 48 separate payments (Granted there are...

Duh, sometime I don't think. Thanks RuralGuy. You are a life saver.

I know what you are guys are saying and I just don't know how to do it. Like I have said I am a beginner and I have no formal or informal training on DB's. Any thing you guys can help me on is greatly appreciated. RuralGuy - I am trying to put in this in to capture the dates of all the claims...

Tables are set up like this: tbl_mbr_info (only one table) SSN LName FName Unit City State Remarks POC POC email The following is data that is being captured per partial for historical data over the next 4 years. tbl_partial_1 thru tbl_partial_48 SSN Claim received MBR sig Date Clerk Init...

Believe me I am open to critizism on my DB cause this is the largest project I have taken on and I am a beginner with this stuff. I don't have 1 claim in 40 tables (or I don't see it that way). I have master table that holds the MBR's info (SSN, Lname, Fname, unit, city, state and remarks)...

I put my statement in there and I get the same result. You saved The Marines here a lot of Hours doing this manually. Thank you for your support. The other way that you are talking about capturing the date I am lost on. I have no idea how to do that. Thank you very much for seeing this problem...

You did it RuralGuy. You are the best....... The [Sent to Disbo] is a Date/Time field. I can not say thank you enough....... Would it do it if I put this statement in: WHERE [Sent to Disbo] = [Enter Date mm/dd/yyyy] instead of WHERE [Sent to Disbo] = #12/15/2005# Would that work or would...

[Sent to Disbo] is a DateTime Field. I got the same result without the paren's.

I am running exactly like you set it up. SELECT SSN, [Sent to Disbo], [Start Date], [End Date] FROM [M00091 Partial 2 Claims] UNION SELECT SSN, [Sent to Disbo], [Start Date], [End Date] FROM [M00091 Partial 3 Claims] UNION SELECT SSN, [Sent to Disbo], [Start Date], [End Date] FROM [M00091...

Sent to Disbo____Start Date________End Date ________________10/1/2005________10/31/2005 12/16/2005_______9/1/2005_________9/30/2005 12/19/2005_______7/5/2005_________8/12/2005 12/19/2005_______8/12/2005________8/15/2005 11/23/2005_______10/1/2005_______10/31/2005...

I looked that up in the Access Bible and looks to be a perfect fit for what I want to do. The only problem I have is I don't know how to write that SQL statement to make it what I want. I will try and see what I come up with and I will post what I wrote.

I used AND instead of OR and now it returns me nothing. Any idea what I am doing wrong? WHERE ((([M00091 Partial 1 Claims].[Sent to Disbo])=#12/15/2005#)) AND ((([M00091 Partial 2 Claims].[Sent to Disbo])=#12/15/2005#)) AND ((([M00091 Partial 3 Claims].[Sent to Disbo])=#12/15/2005#)) AND...

I hope this helps. SELECT [MBR info].SSN, [MBR info].LName, [MBR info].FName, [MBR info].Unit, [M00091 Partial 1 Claims].[Sent to Disbo], [M00091 Partial 1 Claims].[Start Date], [M00091 Partial 1 Claims].[End Date], [M00091 Partial 2 Claims].[Sent to Disbo], [M00091 Partial 2 Claims].[Start...

The reason I have 40 + tables is that a person submits a claim every month for up to 4 years and I have to capture the all the info. I ran into limitation on one table before that is why I split them apart. The Person's SSN links all the info together. I would send you the mess I have created...

I am trying to pull just a specific date that a Claim was sent to be processed. But the query has 40 tables that it needs to go through to get all possible dates. I know you will all say this is over kill on the tables, but each table represent a travel claim. The problem I have is that I get...