Replies

Thanks Hans. It worked!

Thanks Hans. This appears to have worked well.

Now I can’t figure out how to get a query with all the People who have never had an order before. If I just use the People table for the query everyone will show up but if I use the Order and Order Details tables in the query then the people with no orders won’t show up. I’m sure there’s an easy solution to this one, I’m just not sure what it is.

Thanks again.

Thank you. That was very helpful.

This is perfect! I hope I can figure out how you did it. Thanks for all the help.

Thanks. That article was perfect.

Thank you. It was very simple to do. Appreciate the help.

Thanks Again Mark. I figured out the correct format and thank you for all the tips!

Thank you so much! It worked. Now I have to format the currency fields. Is it like this: Format([98QMCSpec].Paid, “$”)?

This is my query when I look at it in SQL View:

SELECT [00QMCSpec].Provider, [00QMCSpec].Field3 AS [Last Name], [98QMCSpec].Members, [98QMCSpec].Paid, [98QMCSpec].[% Members], [98QMCSpec].[% Claims $$], [98QMCSpec].[% of Total], [98QMCSpec].Distribution, [99QMCSpec].Members, [99QMCSpec].Paid, [99QMCSpec].[% Members], [99QMCSpec].[% Claims $$], [99QMCSpec].[% of Total], [99QMCSpec].Distribution, [00QMCSpec].Members, [00QMCSpec].Paid, [00QMCSpec].[% Members], [00QMCSpec].[% Claims $$], [00QMCSpec].[% of Total], [00QMCSpec].Distribution, [00QMCSpec]![Distribution]+[98QMCSpec]![Distribution]+[99QMCSpec]![Distribution] AS Total
FROM (00QMCSpec INNER JOIN 98QMCSpec ON [00QMCSpec].[Provider ID] = [98QMCSpec].[Provider ID]) INNER JOIN 99QMCSpec ON ([00QMCSpec].[Provider ID] = [99QMCSpec].[Provider ID]) AND ([98QMCSpec].[Provider ID] = [99QMCSpec].[Provider ID]);

I tried to add the following to the end of the query, like the article stated:

Field: 98%Members: Format ( [98QMCSpec].[% Members], “0%” )

And it didn’t work. I got the message:
Characters found after end of SQL statement.

Sorry, I’m pretty new at this so I’m not sure what I did wrong. I need all the fields in the query that have a % sign in them to be in that format for the mail merge. Any help is greatly appreciated.

Thanks guys. I will be sure to add the meta tags.

Thanks! Worked perfectly.

That was easy. Thanks so much.

Thanks Guys. I’m creating my first site and it’s so nice to have help out there when your book just isn’t cutting it!

Thank you! Works great.

It was running 3D Flower Box but the strange thing is that we have been running that forever and this problem just started a few weeks ago. I changed the screen saver to blank screen and will see if this helps.

System Idle Process is probably at the top because the CPU usage has already dropped. It’s never at 100% when I’m actually looking at the screen. Another sign that it might be the screen saver I guess. Does anyone know why the screen saver might all of a sudden cause such system slowdown?

Thanks for the help.