Search results

:confused:I have a subreport [qry_projectviewsummary subform] on Form [tbl_projectdetails], I have created the following expression in the footer of the subreport =Sum([Cost]) which provides a SUM of the Cost fields of the subreport. When i reference this in the form, as such...

Hey, thought it was better late than never to actually come say hello here :D so greetings to everyone on access programmers, by far my favourite online resource for helping out with all my access problems. You are indeed a great bunch of folks from which i have learnt many a thing, thankyou...

thanks vbaInet :)

All Ii am after quite simply is a table which produces a log in and an exit time and person / machine name when opening my database, (I do not want to go down the route of using the inbuilt user level permissions for access) I have scripts which work very nicely for getting the current user...

bangs head on desk repeatedly, thank you ever so much for your help guys, havign gone back to basics and checked all my relationships in the DB i have finally ruted out the problem and something that was actually quite easy to do, has indeed now been done. THANK YOU for your patience and time...

help ? anyone please . ?

PNGBill and vbaInet many thanks for your comments, let me try and explain what i am trying to achieve as having re read my previous post, i did not make a particularly good job of it :( (my bad, it was late) tbl_Finance - this table hold individual transaction details for each time someone...

If you download the attached database, unzip, then run - select Frm_home to stat from then run the Mini WIP Report - you will see what i am talking about. I am working on a database which records hours spent working on time charge jobs per person - this is for the engineering consultancy for...

I think i got you on this one Bill, how does this look ? or have i completely missed the point ? - See attached relationships and fields. :) many thanks for taking the time to comment on my question, it is hugely appreciated. Christophe

Introducing the tables and structure to start with, three tables - the common element between them all is the Job No/Project Code, for example CO00507144. Table - Finance. Attr: Project Manager Field2 Job NO Job Title Network Activity Work Stage Employee No Staff Member Amey Fiscal Week Year...

Week Ending BI Week 01/01-2010 01.2010 08/01-2010 02.2010 15/01-2010 03.2010 22/01-2010 04.2010 29/01-2010 05.2010 05/02-2010 06.2010 12/02-2010 07.2010 19/02-2010 08.2010 26/02-2010 09.2010 05/03-2010 010.2010 12/03-2010 011.2010 19/03-2010 012.2010 26/03-2010 013.2010 02/04-2010 014.2010...

yet another annoyance with sap, my database is based on a SAP BI report which is exported into excel, then imported into my database, sadly the date format is MM/YYYY :( is there no other way to get round this ?

I have a table - which lists transactions for jobs, i.e. each entry consists of a member of staff, their grade, hours they have worked, cost and charge out rates etc. From this i have a query - which runs max and min totals on the Fiscal Week Year column, now for the min total - it quite...

Alas, i do not know enough about access to be able to use multiple values, at the moment i am working on the 10/11 charge out rates that should not change for at least the next year, i figured being such a newbie it would be easier to start a new database the following year for the 11/12 rates -...

okay, so i get it now that Dlook is probably the way to go, but when running Dlookup as an expression i get an unknown error - my expression is as follows: which i would assume is saying look in table graderates, for staff member, but i do not know how i would get this to return multiple value...

I have two tables: - Project finance, each line is a single transaction for a job, i.e. how many hours someone has spent working on a project, so for each project there are / will be multiple lines. - Grade rates, a list of staff members, their grade and their charge out rate per hour. What...

anyone :confused: is is that i am not being clear as to what i am asking ... or it just cannot be done ?

New report record created Report is produced Output from database for client Each member of staff logs how many hours they have spent working on the project What i want to be able to do is run a query which calculates the time / charges for that report. So when i select Mr Smith as a project...

I shall give that a try :D many thanks :)

not really, this is an option i had considered tho.