Search results

Thanks a lot Jon

I have set up an Attendance database at work, where a record is created for each member of staff when they are absent. The tables are set up as follows: [tblStaff]: StaffID, FirstName, Surname, Team, JobTitle [tblAbsence]: StaffID, StartDate, EndDate, Issue What I want to be able to do is set...

Sorry forgot to say. Yeah I've sorted this out. Thanks for any help you gave

Thanks for getting back quickly Ken, but I've sorted it now. thanks for your help

as far as you can see though is the code written correctly?

as far as I can see the code is fine. I have had this code working on a different report and have just changed the field and report names but for some reason the pop ups asking for the parameters occur on this one

I've had a look at this and can't see what I'm doing wrong. I have tried this for a seperate report and the same thing is happening. The code for this one is: Option Compare Database Option Explicit Private Sub cmdApplyFilter_Click() Dim strTeam As String Dim strWorkStream As String...

I have set up 2 queries which are working correctly. The problem is when I try to combine them it brings back incorrect information. The 2 queries that work correctly are set up like this Query1: SELECT Projects.[Work Stream], Count(Poles.[New Pole No]) AS [CountOfNew Pole No]...

thanks for the reply

Thanks for replying. I did this before posting but the calculation is coming through incorrectly. The Total cost is found by adding 2 field together i.e. Total Cost:[Material Cost]+[Labour Cost] Is it something to do with trying to do a sum function on a field that contains a calculation

I have a query that is built up of 5 fields with only the 2 below being visible. I am wanting to be able to calculate the total price for each pole no i.e. Pole no 01-02 total price would be £1441.79, What is the best way to do this? Sample data is shown below New Pole No Total Cost 01-02...

The idiot has worked it out, but thanks for looking

Hi, firstly I just want to put I'm a beginner in SQL so don't laugh too loud when you read this. I have a query that takes two field sfrom seperate tables. Lets call the fields X and Y. The X field contains an ID number (there are 6 possible instances) which can be duplicated many times. The Y...

Thanks for replying Ken but unfortunatly this doesn't work

I have set up a report called rptAbsence, and also a dialog box called frmAbsenceFilter. This dialog box is a form containing a combo box and 2 command buttons (apply and remove). The combo box comes from a table called[Issues]. The problem I'm having is when I apply the filter a box pops up...

thamks sergeant

I have 2 tables for an attendance database. The idea is that whenever someone is absent they have a record created. tbl[Staff] has the following fields StaffID,FirstName,Surname,Team,Job Title tbl[Absence] has the following fields StaffID, abStartDate,abEndDate,abIssue I have set up a form for...

thanks have it sorted now

I have 2 tables and a query to show the details of both tables on a form for an attendance database. The idea is that whenever someone is absent they have a record created. tbl[Staff] has the following fields StaffID,Name,Team,Job Title tbl[Absence] has the following fields StaffID...

I have 2 tables and a query to show the details of both tables on a form for an attendance database. The idea is that whenever someone is absent they have a record created. tbl[Staff] has the following fields StaffID,Name,Team,Job Title tbl[Absence] has the following fields StaffID...