Search results

Sure thing! Here it is. Thank you!

I only want to show the types that a particular client has, many clients usually just have 1 source of income but very often have multiple types of expenditure. Here's the SQL code for my query: SELECT IncomePaid.[Account Number], Income.IncomeType, IncomePaid.AmountPaid, Income.ExpendType...

Hmm, when I do the report it only shows the first entry of income and the first entry of the expenditure for each client. For example, if client A has 2 Income types and 4 Expenditure types, only the first one of each is shown, then beneath that it shows client B's income/expenditure. Could this...

O.K, got it, so, I've merged IncomePaid & ExpendPaid, and I've merged the Expenditure table with the Income table. The Income table now has all the IncomeTypes AND all the ExpendTypes, and the IncomeType table now has all the Income/Expenditure details that have been entered by the user. Have I...

I know about the spaces thing now, when I first started I didn’t and instead of going back and changing it all I decided to jus t leave it but apply that knowledge to anything new I created. Anyway, in answer to your question: The Address fields on BasicDetails are the address details of the...

Here's the database, some of the earlier stuff I developed was when I was a bit of a newbie so I realise there may be some techniques used that are frowned upon! Anyway, thanks for helping :).

Ah, well, I can save the back end as 2003 but when I try to convert the other half it says it cannot be converted because it uses features reliant on that version. Is there anything you can do with just the back end?

Yep I'll have to duplicate the back end and put some dummy data in so I'll upload it when that's been done!

Hmm, I don't think I can do that, I actually have 4 tables (2 for income and 2 for expenditure), the first table is a list of different IncomeTypes. Each IncomeType has an IncomeID. I've named this table Income. Now, in the next table (which I've called IncomePaid) I have the AccountNumber, the...

Hey all, I'm having an issue merging two queries of mine. Basically one shows a clients income and the other shows a clients expenditure. The tables in both queries consist of an Account Number, a Type and the AmountPaid. Usually there are more entries in the Expenditure query, but when I join...

Hmmm, well, I've taken out the code I put above (which was on the AfterUpdate and OnCurrent), created a button and set the code on the OnClick to: If Len(Me.Narrative.Value & "") = 0 Then Me.Narrative.Locked = False Else Me.Narrative.Locked = True End If However, now I can't type anything...

Hey, This is probably a really simple question but I can't seem to find the answer anywhere! I have a query that shows when a client needs to be distributed (DistribStart). I want to display all records due to be distributed this month and also next month. How do I do this? Help would be...

Hey guys, I currently have a Note box on one of my subforms that locks after something has been entered and the user has clicked out of the box. Now, this worked at first, but one user has been trying to copy and paste information from some of the other tabs and when she leaves the current tab...

That's brilliant Guus2005!! It works! I'm still getting my head around IIF statements, your reply's helped though, at least I can apply this to anything similar in the future :). Thanks again!!

Hey all, I'm having an issue with a query I'm trying to create. The purpose of the query is to ultimately create a 'performance' report so management can see how well a particular employee is doing. We have two types of employee's, filterers and advisors. A filterer finds leads for the advisor...

Hey all, I'm having issues with a Total's query I'm using in my database. The query returns a count and then a sum of the amount of leads we get from a broker. Now, I want to find out how many leads have been given to us between two dates (which are entered by the user). The current Total query...