Search results for query: *

I have a spreadsheet which on the first page "League Table" has a list of peoples names(col A) and their scores (col B)example Adam 5, Colin 8, John 13, Terry 16 etc.. I also have a worksheet for each person in the same workbook. example Adam , Colin, John, Terry etc... I would like to be able...

Sorry, These are two actual records from customer table AccountNo 123456 Name John Smith LAmount 100000 AccountNo 987654 Name Peter John Lamount 75000 These are related records from the transaction table AccountNo 123456 DrawndownAmt 30000 DrawdownDate 12/5 AccountNo 123456 DrawndownAmt 8000...

Sorry, Example 1 January 06 Account No Customer Full Leftto Amount Trans take 123456 Mr Smith 50000 30000 10000...

Month Jan Account Full Amount Amount Taken Amount Left 1 5000 1000 2000 2000 2 7000 0 7000...

Hi, fairly new to reports in Access and was hoping someone could give me a hand getting some totals in a report. I have four columns:- Month Full Amount Amount Taken Amount Remaining (Unbound Text Box) which is Full amount - Amount Taken I have these grouped by month, my problem is getting...

Hi PHV Thanks, I have typed my SQL (see below), and have used T1 and T2 as my Alias for my tables, but I am getting 'Syntax Error in Join Operation' Any suggestions SELECT T1.AccountNo, T1.LoanAmount - Sum(Nz(T2.DrawdownAmount,0)) As Balance FROM [T1] AS A LEFT JOIN [T2] AS T2 on T1.AccountNo...

Hi I have a database put together which has two tables, one is for product and the other is for transactions. The product table is related to the transaction table by account number. Table 1 will provide an item which we will say is €50.00 Table 2 will show payments i.e 2 transactions for...

Sashanan2 I am a bit of a novice on this, can you explain! How does T1 and T2 look joined, but not T3? Thanks Perry

Hi Guys, I have the following query, which is working well, except on the part where I am looking at 'Client Status'=1. The query returns all of the ClientStatus results not just the 1's. Any help would be gratefully appreciated. Thanks Perry INSERT INTO EnquiryTemp ( PropertyID, ClientID...

The problem has fixed itself. I closed down PC (restarted) and hey presto the thing works. Welcome to the mad world of Access databases.

Remou Link child and master are set to OwnerID on the Subform. I have an old copy of the database, and it works fine on that!! Access is crazy! Thanks

Hi, would appreciate some help on this one, as it is driving me crazy... I have 2 tables. One called Owner, the other property. They are related 1 to Many. i.e one owner can have many properties. I have a FK in the property table (OwnerID), now for the problem. I can add a new owner and a...

For all the fields that contain a number i am using the SUMIF function to return the numeric values in SS2, is there an equivalent function to return the text value? Hope this is clearer Perry

Hi I have 2 spreadsheets(SS1 and SS2), one which holds the main information, and another that holds some info from SS1 and some new stuff. What i need to do is the following SS1 has Ac No (Number),Amount(Number)and Ac Name (Text) SS2 has Ac No (Number),Amount(Number)and Ac Name (Text)etc...

Does anyone know if it is possible to import from the comments in excel (small yellow comment box in excel) into Access. I have a spreadsheet that I need to import into access which has about 300 rows, one of the columns has Yes or No in, plus comments attached. Can the comments be either...

Tony, Yes just for visual aid, but the spreadsheet is rather large, so I dont want to have to do the lines individually. How would this work? Perry

Hi, Does anyone know of a way of inserting a row automatically after each total. Thanks Perry

I have done tried this and still not working. Field Value is Equal to Active Then i have my formatting, but it doesn't work? Any idea as to why Thanks Zameer

Yeah Access 2000. But whatever I try doesn't seem to change the colour? Do I use Field Value Is or Expression Is? Thanks

Hi I have a Combo Box and would like to set the Color of the box dependent on the items selected from Combo box? Any ideas pls. For the record, the Items in Combo box are Text Thanks Perry