Search results

I have search the forum 1st it usually gives me the answer I need, but what I am trying to do it populate a combo box after I type in a text box. What I want to do is Type in the the city and when I go to the combo box it only list the Units in that city. I have a couple of table and I may...

I have tried to following the example in the Access 2000 bible on how to build one and that is why this is in the forms section since you do it using a form. Anyway, I have created the Pivot table in excel by exporting the data from a query in access, but I would really like to just have it in...

Okay I have sat here tonight reading over this forum trying to digest all the info I can and the lite finally turn on. neileg your idea finally makes sense to me. Sometimes you have to hit me with a brick to make me understand what you mean and now i understand my flaw. Now I to figure out...

Here is a sample I got from this site that works great for me. Just a thought.

I got the query to work with a little bit of rigging it. As for the structure of the DB I am always working on it. As for the number of tables I have? I have yet to figure out a way to capture all the data, dates and other info that specific to a Single claim (members could submit up 48...

Thanks guys, I guess it is back to the drawing board on this query.

I think that my problem is that this is a query on top of a union query that isn't returning any data to count. How would I correct this? union query is listed below: SELECT SSN, [Disbo DN Date], [Order Type] FROM [M00091 Supplemental 1 Claims] WHERE [DN Date] Between [Type the beginning date...

No, I thought I would. I will go over the query again.

What i want is if the query find zero records to count then I want it to return a zero and not a blank.

I tried these where I want the query to count the records. it looks like this: Field: Countof SSN TABLE: Disbo_dns Totals: Count <====== is this where I put the Nz([FieldName], 0) Sort: Show: Criteria: or: I am a little lost here. I just want to count the records and if no records are...

okay. Thanks for your help guys.

Okay using the wizard worked great to carry the SSN over, but it won't allow me to click on other members in the P1 Form. How do I get the P1 form to go back to being able to search for other members in that form? You might have multiple claims to enter on the same form. The only way I could get...

Thanks, I will give that a try and post tomorrow if I have any problems.

Pat - can you give me a little help on how to write that argument? Please.

Thanks it worked great.

Sorry about that guys. If on the search page you click on a person and it populates the info on the right. If there is anyway if you click the radio button it captures the the persons SSN and when you go to P1 or P2 that persons info is already populated on the right side of the page. At minimum...

would that work with alpha characters as well or is that something different?

I have attached a sample of my DB so you can see for yourself what i am trying to do. I want to capture the SSN on the search page so when I go to P1 or P2 that persons info is all ready populated on the right side of the page, but still allows for a search after I have updated the record. Any...

Okay I figure it out guys I have attached where I changed the name in the Textbox. it was in the other TAB and I changed the name to Last 4 and now it works... Thanks for your patients with me. You guys are awesome. :) :)

Please look at what I attached and see if that what you mean by changing the textbox to something other than SSN? If that is what you mean I tried that and get the same error message on the report. If I use the say box and use the code =Right([City],4) it works for the city in that box. I will...