Search results for query: *

Thanks, that sounds kind of like the difference function. Sorry to sound dense but I have an access name called T_NAMES with fields first and last and a second table called T_NAMES2 with same fields. Can I use this code to compare the two?

I understand there is a Soundex and also a Difference function available in SQL Server. I am not too knowledgeable with VB but here is my dilemma. I would like to compare two tables that have first names and last names and I think the Soundex function may be of help. I've read about the...

Thanks a ton Duane. I'll give it a whirl. Wasn't sure if there was a way to write the SQL within Access to have just one query.

Hi Duane, I do have a total. It's is like my data is: County,Name,Product Allegheny,joe's dialysis,HMO Allegheny,joe's dialysis,PPO Allegheny,joe's dialysis,POS Allegheny,jim's dialysis,HMO Allegheny,jim's dialysis,PPO Allegheny,jim's dialysis,POS Allegheny,tim's,dialysis,HMO Allegheny,tim's...

Hi, Maybe this problem has been beaten to death. However, I'm looking for a viable solution to a crosstab query problem. Basically, here's the SQL: TRANSFORM Count([ANCILLARY MASTER].NAME) AS CountOfNAME SELECT [ANCILLARY MASTER].COUNTY_NAME, [ANCILLARY MASTER].SPECIALTY FROM [ANCILLARY...

Hi HiTech and WorkrAnt, I was (am) trying to calculate the maximum of some fields in a row (rather than in a column) and thought something might be better than: IIF([malepercent]>[femalepercent],[malepercent],[femalepercent]) and then do the same thing for the other field in the row. Doesn't...

Hi, I have a query that has something like County, Male Percent, Female Percent, Robot Percent(kidding) grouping on the county. Can I run a query in MS Access that can MAX on the row and update a column OR give me a new calculated field? Thank you, easy to do in a spreadsheet but I'd rather...

Hi, I'm struggling with an odd problem. I have a main form that with some list boxes. These have command buttons that bring up forms in the datasheet view. Only problem is that I lose the close buttons on these forms for some odd reason. I have it enabled. Wondered- to get around this, if...

Thank you. I'm using Access 2002. I added in the event proceduere and that works fine except that now I lose the close buttons even though I have them enabled on the properties sheet. I have to use the min/max buttons in order to see them.

Hi, I have a couple of, I hope, not too complex questions. 1. Everytime I close the datasheet view now, the form returns to my original main form but it does not fill the entire available window. I don't need any scroll bars or min/max buttons and I've disable them but it still does not expand...

Thank you ShannonSkipper. That's most helpful.

Hello, I was looking for a bit of direction on a project. I had a table that has data and it is grouped by state counties. I made a datasheet form from this. I will then put the database on a network so that people can audit the data through the form. Since there are 88 counties in the data...

Duane, MichaelRed, Thanks a super ton. Really- I'm trying to avoid using an outside report generator and this gives me a lot of options. Love the examples you had Duane. Professionally done to say the least.

Duane, Thanks very much. I'll take a look now. Sure this will do the trick.

Hi, apologize in advance if this has been addressed too many tabs. I couldn't see anything in the FAQ's that relate. I would like to have a crosstab query create results where the list of state counties are the columns. Then various (about 5-6 calculated fields) fields become the rows. I...

TT4U, Wanted to say, thanks again- think I got it working. I did not go into safe mode but I made a couple of adjustments and not sure what did the trick. However, I did lose some of my disply colors when I re-booted. Basically, I deleted all the cookies and also I think I zapped a...

Thank you again TT4U. I'll give it all of those a look see. I started having these problems when some programs started to load onto my machine when I was logged on.

Thanks TT4U- I'll try running the rundll32.exe from the install CD. Can you tell me how to boot into safe mode and also what running msconfig does? Is that kind of a disk defrag (don't think so but thought I'd say that to show how little I know about this)

I can establish new connections but I still can the Rundll32 error.

Hi, I'm a DB guy so network issues are my definite weakness. Got a real issue as I cannot use my dial up Internet service nor dial into my work mainframe. I'm using Windows 98 and so far I have: 1. Reinstalled Windows 98 and reinstalled I.E. 5.5 but get the same error. I didn't remove the IE...