Getting Started

I didn't see your posts until just now. Not sure what
John & Ken, I didn't see your posts until just now. Not sure what happened, however they did not come through for some reason. All 3 of you (including Jeanette) agree that it's a bad idea to do what I was going to with the multiple yes/no fields. Looking back on it, your right, not the smartest thing I've come up... 28 Jan 2010 01:00

Table data update
I have a table that contains several fields but I am only concerned with two, OldPrice and NewPrice. On my form for entering new data both of these fields show. The custermer is charged using the average of these two fields. My problem is that when I enter a new NewPrice I need to have the OldPrice field update... 2 Feb 2010 17:25

Jeanette, thank you for your help. I thought of doing it
Jeanette, thank you for your help. I thought of doing it the way you suggested initially, but talked myself out of it. Guess I should have trusted my instincts on this one. :-) I will go with what you suggest. It looks like a much better way of doing it. Thank you, Tara Jeanette Cunningham wrote: Settin... 27 Jan 2010 16:04

Tables & Relationships
I have three [primary] tables in a new database I'm trying to create. They are (1) Company, (2) Contacts, which is related to the Company table as we may have multiple Contacts for the same Company, and (3) Job Numbers, which includes details associated with each particular job (including a field for Company a... 2 Feb 2010 17:25

Linking fields in different table in same database
I have a database (Access 2007) that is used for holding data on and communicating with FE colleges. Obviously (?) each college has a number of contacts (up to 14) and these are represented in two tables – one for College Details and one for Contact Details which are linked by a one to many relationship. Most ... 27 Jan 2010 11:30

[newbie] Expression for building a percentage
I need to create an expression that basically creates a division as follows, adding it as a new field within the SQL query. Change (%) = Quantity of previous year / Quantity of this year SQL Query SELECT Format([Date_of_Reg],"yyyy") AS [Reg Date], Format([Date_of_Reg],"q") AS [Reg Date-q], Car_Model.Manuf... 27 Jan 2010 09:15

Latest occurrence for same person
Hi. I have db with a number of people and they do a certain type of a course, but they have to have refresher courses every couple of years. How do I get a list that has one occurrence of each name with the last time they took the course? e.g. what I have: Name Course Date Joe 1A 01/05/... 2 Feb 2010 17:25

I have two Yes/No fields in a table (ContractorInstall, and InHouseInstall)
Setting up Yes/No fields for this is better avoided. Create a table for InstallType. tblInstallType InstallTypeID - autonumber- Primary Key InstallTypeName - description of the type In the main table, put InstallTypeID as one of the fields. In the relationships window with both the main table and the install ty... 27 Jan 2010 14:55

I have two Yes/No fields in a table (ContractorInstall, andInHouseInstall)
I have two Yes/No fields in a table (ContractorInstall and InHouseInstall) What I would like to happen in the form is as follows: Since one of the boxes must be checked (yes), the checked box will display either the contractor or the in-house survey depending upon which one is "yes". If it's a contractor install, the ... 27 Jan 2010 01:36

counting in fields
Please help Please note I am not use to using Access I would like to be able to count items in fields. I have a table which I produced by doing a query of 2 tables and making it a query table. The fields are Client no, Date, nationality, gender, postcode, marital status, and a few others. I can do a cross tab que... 2 Feb 2010 17:25