Search results for query: *

Hello all. I'm stumped with this one and would be very grateful for some help. I have a Form with contains a tab control with a subform on each of the three tab pages. (It so happens that there is a one to many relationship between page 1 and 2 and page 1 and 3. The database is growing fast and...

Hello All. I have a stacked query which returns a series of rows of numbers (1-5) which refers to one of 5 columns in a table. How can I (or maybe I can't do this) code the column names with the numbers returned from the stacked query. Here's an example of what I want to do. I want to end up...

Hello All. I have a stacked query which returns a series of rows of numbers (1-5) which refers to one of 5 columns in a table. How can I (or maybe I can't do this) code the column names with the numbers returned from the stacked query. Here's an example of what I want to do. I want to end up...

Hello Everyone. I need to get back two values from a query - 1. the total number of rows in a table and 2. the number of "incidents" which have been "signed off" (i.e.) dealt with successfully within 48 hrs. The two values are intended for a pie chart. Here's what I've got...

Hello Everyone. I need to get back two values from a query - 1. the total number of rows in a table and 2. the number of "incidents" which have been "signed off" (i.e.) dealt with successfully within 48 hrs. The two values are intended for a pie chart. Here's what I've got...

It'll probably be more clear if I show you the query I'm using: SELECT DecontaminationRecord.Location, Sum(DecontaminationRecord.LOShrs_mins) AS LOS_SUM, tblLocation.Loc FROM DecontaminationRecord, tblLocation WHERE (DecontaminationRecord.[Date] = [Forms]![frmGetDate]![DateForReport]) and...

Please excuse me if I'm being dense here. This is the problem: Personnel database which is used by various departments each with a table and form recording relevant data. The Main "Workforce" table generates an autonumber which is then used as that person's "ID" and is the...

I've got the Access 2000 Developers Set but they seem to expect me to know a bit about Joining tables - I don't. So, can some kind person point me to a web source (tutorial?) which will explain what it's all about - Inner / Outer / Left etc. Cheers, Peter

It's a bit messy this one but I'm sure somebody must have done something like this before: There's a main table which has (at the moment, but could have more later) two tables which hold details about the main table. These have a 1 to M relationship with the main table and we have the...

Sorry everyone - I have searched for info on this but can't find what I'm after. I have a subform (Continuous Forms view) which does a simple row multiplication based on a value selected from a combo - the multiplication appears in the sub-total column and the calculation is done in the...

Access programming is "not" how I normally make a living but I've been asked to undertake a (3 week) project to set up some databases involving some programming. What would be a reasonable weekly or hourly rate in the UK? I'm a C++ programmer, recently started with access and VBA. I...

I'm new to access programming so please forgive me if this is a stupid question. I have a form with some fields which do some capitalizing on exit - e.g. Private Sub Address_1_Exit(Cancel As Integer) If Not gCapitalize Then Exit Sub Me![Address 1].Value = StrConv(Me![Address 1].Value...