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...

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 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...

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...

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...

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...

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

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

Hi, I have a database that has a 1-M relationship, which is et up as follows. Table1 OwnerId (Key) Name Table2 PropertyId (Key) Owner Any owner can have own more than one property, which is working fine, but everytime I add a new owner the relationship window shows Loads of links (One for...

I have two tables. 1. ClientTable (ClientId key, autonumber) 2. RequirementTable (RequirementID key, autonumber) The Client can have many requirements Example Client 1 John Requirement 1 Tea Requirement 2 Coffee Client 2 Peter Requirement 3 Tea What I would like is Client 2s requirements to...

I have two tables and am running a query to append the results of a query into new third table, however if I run the query again I dont want to append duplicate records into the new table. Any advise please.

Hi I have created a database which consists of three tables 1.Client 2.Property 3.LinkClientProperty My Client table holds info about the client and their requirements. i.e 3 bed house worth 150k (ClientID key) My Property table holds info about the properties which are available to buy...

Hi I have two tables which hold data, one has a list of enquirers, the other a list of properties. I need to know how would you match the enquierers to the correct properties. I am ok on stand alone tables and queries but new to linking between them. Any help would be gratefully aprreciated...

Hi, a friend of mine is using word 97 and when they are printing their document, instead of getting 1, 2, 3 etc for page number it is printing PAGE. I have checked in options for the field codes, and this is ok. Does anyone know how we can get the page number itself to appear on the print...

Hi is it possible to write a query, which looks at a Wildcard entry or what is entered in the Parameter option. Basically I am trying to write a query where the User has the option to search for a Customer on Either First or Surname, but prefabably in the same query. So if they know the first...

Hi, I have a form which runs off a query, I would like to be able to edit details in the form. But when I try to overtype or add it is completly disabled! Though in properties "Allow Edits" is YES, any ideas?

Hi I have a table that has a reference number, I would like to add a letter to the front of the reference number. How would i go about doing this in an update query? Thanks Perry

record. Basically I have a database that has lots of records. One of the fields is an autonumber. I have a form set up which displays 5 of the 10 fields from the table, I also have a button which when you click requests the autonumber. (Running off a parameter query).Which will then display...

I have a table where one of the fields is a reference number, the reference number starts with a letter followed by a number.Example A'1, A'2, A'3...A'11, B'1, B'2 etc. At present when sorting by this field I get the following list. A'1 A'11 A'2 A'3 B'1 B'2 How would i go about making the list...