Search results

  1. B

    I need to consecutively number table rows with user determined start number

    I tried, through my wordy introduction, to explain the reasoning behind this. We essentially have three categories of dealers. Some are paid a % of the policy amount, some are paid a fee per quote regardless of whether the policy is sold, and some are paid a set fee per policy. Because of...
  2. B

    I need to consecutively number table rows with user determined start number

    I'm open to any and all suggestions. I appreciate any suggestion that may smooth the way.
  3. B

    I need to consecutively number table rows with user determined start number

    Make table SQL is: SELECT Commissions.DealerID, Commissions.DealerName, Commissions.IndName, Sum(Commissions.AmtPaid) AS SumOfAmtPaid, "Commissions from " & [Forms]![BinderReport]![Start] & " to " & [Forms]![BinderReport]![End] AS [Memo], Commissions.Address, Commissions.DealerCSZip...
  4. B

    I need to consecutively number table rows with user determined start number

    Yes, the three queries are all totals queries.
  5. B

    I need to consecutively number table rows with user determined start number

    The reason I need the extra table is because the queries that feed it (Make Table + 2 Appends) are all totals queries. The original record set has the individual line items, while the queries sum the totals for each dealer so that we have Dealer X and his total amount as one line item. The...
  6. B

    I need to consecutively number table rows with user determined start number

    I have an Access2007/SQL Server 2012 system with 20 users for an insurance company. I've been accused before (fairly) of being wordy in my descriptions, but it's the only way I think those I'm asking for help can fully understand what I'm doing. The company does most of its business via a...
  7. B

    I need a creative way to set control source

    I just wanted to thank all of you for your input and help. It's all complete and functioning properly.
  8. B

    I need a creative way to set control source

    Thank you all for the advice you've offered. I'm going to start transferring records to the new table. BTW, am running SQL Server 2012.
  9. B

    I need a creative way to set control source

    Whoops I edited you post instead of quoting. I have almost done this so many times.
  10. B

    I need a creative way to set control source

    Currently we have nearly 100,000 records in our database. If I create one record per company per CustID , even if we have a low average of 5 companies quoted/customer, we'd still be looking at roughly half a million records in the new Rates table just to catch up with where we are now. The...
  11. B

    I need a creative way to set control source

    I thought long and hard about your comments before responding. You're absolutely right. What I have been proposing is an Excel solution. Thank you for the reality check. Let me ask something. We have a report called Competitive Pricing which is output in Excel format. It has demographic...
  12. B

    I need a creative way to set control source

    In general I agree with you, but this is a unique situation. I could have ten or more quotes from ten or more companies for one customer, and the logic (if you can call it that) behind naming the data fields the same as the company name is that we are in long-term relationships with these...
  13. B

    I need a creative way to set control source

    I really tried hard in the last post to be as brief as I could be and still remain understandable!:D
  14. B

    I need a creative way to set control source

    This is a place to store the comparative rates of different companies. As I mentioned, For Customer 1234 Company A's rates were $100, Company B's rates were $120, Company C's rates were $140. There are many uses we put that data to. Each one is a currency column named with the name of every...
  15. B

    I need a creative way to set control source

    Maybe someone can suggest a better solution, but the main issue you need to be aware of is that I'm running out of fields, both in the main table, and also in the queries that feed the main customer forms. I have 9 fields remaining in the table, and even though obviously I can get more space by...
  16. B

    I need a creative way to set control source

    Thanks for your advice, gents. I will rethink this whole structure based on your suggestions. The more I think about it the more I agree with you. The solution I was working on is probably going to come back and bite me in the ass down the road. BTW, I was able to solve my original question...
  17. B

    I need a creative way to set control source

    I have an Access 2007database, SQL Server , 20 users for an insurance company that has been established for more than 4 years and is working well. There was a serious error made when it was originally set up. Each insurance company was assigned its own field with its own name as a place to...
  18. B

    Which event precedes "another user has changed record" error in Access 2007?

    Re: Which event precedes "another user has changed record" error in Access 2007? Thanks. I don't think that is applicable to what I'm doing, unfortunately. The queue staging table is fed from the web interface, but once there, the transfer to the main data table is controlled by a user...
  19. B

    Which event precedes "another user has changed record" error in Access 2007?

    Which event precedes "another user has changed record" error in Access 2007? I have written a live queue for an insurance company. When a user inputs info on a web form it is immediately placed in a staging table in Access 2007 housed on SQL Server 2008. The count of unassigned records in...
  20. B

    How do I create text for a number like "one thousand (1,000)"?

    That is ultra cool! Thanks!:):)
Back
Top Bottom