Search results

Thank you both. I will look at the sample, I had tried to do it the way I had mentioned but for some reason I had run into an error. Now that I know it is doable I will look at the samples. Eva

Hi, I asked this a few weeks ago but never got an answer. In SQL, is it possible to do a Select Top 10 By Person. Thanks, Eva

I know to normalize the database I really should break it down into several tables. I took over a very messy database and there will be making their own queries in the database who do not understand normalization. To do the database right, I should set it this way: Table 1 CaseNumber...

thanks for the answer. Big help. I also want to double check. Can I put Date sent to Agent and Amount Sent to Agent in the Agent Table. I understand the use of using id number for agents but can I get away with just using the names. Right now I only have two agents that have been used since...

Hi, I am trying to normalize a collection database that has 10 years worth of data. In Table 1, I have data on client that owes money, plus the following fields, collection agent, date sent to agent, amount sent to agent. In Table 2, I have Payment Number Payment Date Payment Amount I want to...

For my report when there is no data, i currently have the following code: 'Closes the report if there is no data MsgBox "There are no Known Losses for the period you requested.", , "No Data" Cancel = True without that code I would get #error if there isno data. I came up with one...