Recent content by biggcc

Created a query that brought back all the loan values in approx. 25 columns. Now the reqest is to bring back the max value from that range of columns/fields. That wasn't a problem. The problem is now they want the next 3 lower values to show up for a range of accounts. Here is what I used to get...

Thanks - Now I get it. Unfortunately I don't have time right now to try it but I will either from home tonight or at work tomorrow morning and will let you know how it works. I'm hopeful that it will solve my problem. I'll let you know how it turns out.

I'm following what you suggested but just have one question. I don't know how I would aggregate it on that field. Could you provide an example of what you are talking about? My end query is a combination of approximately 8 other queries that all supply their piece of information. I guess I'm...

I'm trying to figure out if this is possible or not. Here is a brief overview of I'm trying to accomplish. I have multiple properties that I'm collecting data for so the key field for all queries is the property number. Currently all my queries work as designed. What they have asked for now if...

Weekly Totals THANKS JonK. After some slight tweaking it does exactly what I need it to do. I have 4 different queries that show prospect traffic for the current and prior 3 weeks. Once I adjusted the number after the Date()) entry to the corresponding weeks it worked GREAT! Thanks again...

Weekly Totals Thanks Jon K - you gave me enough information so I could get what I need except for one small detail. I would like to display the last date for the week close and I can't figure that one out. Here's what I have currently that gives me the weekly totals I was looking for. SELECT...

On the attached jpg(s) you will see the query I'm working with. It's fairly simple except for a couple of things and those are the items I'm stuck on. What I'm trying to do is get a representation of the amount of traffic that has come through our salescenters in the last week. Some centers...

More Info Sorry I thought I supplied enough information but after reading it back I can see I missed some things. Moniker is right in that I'm trying to use a date/time field for pulling records and it is not the key field. There is a random id field generated for each entry and that is the...

I'm trying to figure out how I can pull the most recent entry in a table for each of the properties in our database. Let me give you some background. This access database is used to format reports from an SQL database - all of the tables are linked and all of my other reports work great except...

Many Thanks Cosmos75 What you gave me worked great! (aside from a few tweaks) My only question is if there is a way to speed it up. It runs sort of slow and the database will only get bigger. I was thinking that I could have it first create a table and then set it to append that table but when...

Here is the situation that I'm hoping that someone can help me with. I'm working with a database that tracks our condo units - from prospect coming into the system until we close them as a buyer. All the units are setup in the system so a salesperson will select from the units available. All...

Report from form Hey Bob maybe you can help me with one thing I'm having a problem with on this form. For some reason after I make my selections they stay on the form so if I go to run the report again the old selections are still there. I have tried several things like me.refresh but nothing...

Report from form Works now. Created a new form and did everything again and now it works. Strange? Anyway thanks for your suggestions. Chester

Report from form Yes I know - that's what's usually happened in the past and I've gone over it multiple times to see if everything is correct and I can't find anything misspelled. Anything else you can think to check? Thanks,

I done this many times before - created a report whos results are based on the parameters selected from a form. Now for some reason when I go to run the report my form comes up and allows me to select the data but then I get another pop-up screen that asks for the parameters again. If I enter...