Search results

You need to explain better what results you are trying to get, and what results you are actually getting.

One basic problem to look for when things work on one machine but not the other is that there are things stored locally on the C: drive of the machine that functions properly. I've run into this when I forget to move a linked table to a shared area, and that linked table is buried in a query...

do a search for LTRIM

I would not expect performance issues, those are not large numbers for Access. I run into performance problems writting reports on tables with 2 million records. ;)

I guess I'm not understanding the problem. If row 2,3 & 4 are text, then it won't = 4, and therefor won't get an X.

Can you define the condition that is causing you to skip a row?

Mail merge will produce 1 letter for each record. You'd get 3 letters for Mr. A. Try using a report instead, with a grouped query. Query Example: SELECT [MYTABLE].TUTOR, [MYTABLE].STUDENT FROM [MYTABLE] GROUP BY [MYTABLE].TUTOR, [MYTABLE].STUDENT; Then you can format the report to look more...

Ohh you need a random name generator. :eek:

The results you are getting are expected, you are joining the company to the call table, so you get one record for each call. Distinct isn't going to help you eliminate the duplicate. What call records are supposed to be in the report?

Random being "any" record, it did the trick.

Well the solution for this dawned on me this weekend, and it was so simple as to be embarrasing...:rolleyes: but I'll leave it here for others who are looking. min or max will result in only one record for each of the plans. SELECT [Plan Number], Min([SSN]) AS MinOfSSN FROM [TABLE_NAME] GROUP...

Less and less people know the code behind the pictures...that's good for us dinosaurs that know the words...:cool: I would export the results to Excel to make the chart using the chart wizard. Then you can make a picture out of the chart.

Ok, I gave you a query to use...and you said it didn't work. Try using it. :rolleyes: Select distinct is not the way to get your results.

That is what the query does; it would help if you posted the query you used.

I ran into this link when I was searching, I do not understand how it can get me one record for each plan, it seemed it would get me 100 random records from the 200,000...but I know SQL not VBA

Try this SELECT NAME, Count(NAME) AS [CountOfNAME] FROM [NAME TABLE] GROUP BY NAME;

I've read-up on getting random records, but I need a little help. I have a table with 200,000 SSN records. Fields: SSN, Plan Number There are about 100 distinct plans. How can I select a sample (random) SSN for each plan?:confused:

Thanks, maybe I'll ask the powers to be for an upgrade...unless I can get that SQL server I've been asking for. ;)

That's just what I'm looking for, but there is no "object dependencies" in the view menu (Access 2002).

Is there short cut way of discovering what queries, forms, reports or macros are making reference to a particular table? I'd like to make some changes to the layout of a table to make it more efficient, but I know I'll break some queries that rely on the current structure.