Search results

You can do this in 2 stages (ie. with 2 queries). The first query Groups By two fields - Customer ID and Employee ID - and Sums the Duration field. This will give you a total duration for each Customer/Employee table. You then join the result of this query to the one you have below (joing by...

Hi folks, I have searched, but not found an answer to this question. I have a form with no 'Details' section - just half a dozen fields in the form footer all of which are SUMs of the fields in the underlying query. The trouble is that the fields appear blank until I either click on one of...

Hi all, I see several examples of Median functions on the forum - but they all calculate the median of an entire dataset. I'm looking for a version that would allow me to run a subtotal query with median values. To be specific, I've got a table with Job Title, Grade and salary. I want to group...

Hi there, I'm about to embark on writing the front end to a data warehouse which will consist mainly of reports being run where the user has set the criteria dynamically. As far as I can see there are at least 3 ways to do this ; 1. Use criteria in the reports query which look up field values...

Thanks G, I have a follow-up question :-) I've been told that all pcs up here should already have Access Runtime installed. How can I check that this is the case ? I can't see anything obvious on their Start menus. Also - if a pc has runtime installed, should they be able to open an MDB/MDE...

Hello, I have a question about Access runtime. We have some users at work who don't have Access on their machines, but we would like them to be able to use databases we have created. My suggestion was to purchase Visual Studio Tools for Office, which will give us Access Developer Extensions and...

Hi G, Thanks for your help with this. Here is code from the forms beforeUpdate event, my "Print Process Sheet" button, and my sub "checkKeyFields" which does the validation. I've cut out some of the stuff to make it simpler to read, but basically the logic is all there. Bizarrely, clearing out...

Thanks G, that will be useful - but I think I am still missing something. If I put all my validation in the beforeUpdate event, I seem to have problems cancelling the calling action. I have 3 buttons on my form ; "Print Job", "Add another Job", "Exit". For each of these the first thing I do is...

Hello all, I have a table with 4 required fields, and a form to add new entries to the table. While testing, if I don't enter a value in one of the required fields, and press the standard 'X' close button at the top right of the form, I get an error message "The field xxxxx.xxxxx cannot contain...

Hi I have two tables - one which holds call data for telephone calls, the other of which is a lookup with dialling code information. I want to link the first 5 digits of the dialled number with the area code in the lookup table. Fine so far - but the resulting recordset is not updateable. Is...

Hello all, I have a form where I want to validate enties before moving off the record. I put my validation in the BeforeUpdate event of the form. If validation fails, then I set Cancel=True. So far, so good. But if the user closes the form (either with my close button, or the standard close...

Hi folks, I've built a few simple databases in the past, but never one where security was required. Now someone wants a database where access to certain areas is limited. Everything I read about Access Security here makes it seem complicated, and flaky, so I was wondering about doing something...

Hi there, First set up a simple query, to show Employee ID, Session number and Tax_YTD. Sort it by EmployeeID , and Session number (ascending). This will give you all sessions for each employee - to stop it doing this you want it just to output the last record for each employee. So, select...

Hi there. It might be simpler, if the report is already written, to change the text box where you are currently displaying the code, to a combo box. This can be set up just like a combo box on a form, with 2 columns (first column hidden) so that it displays the description, rather than the code...

Hi there - this should pretty much be the same in an Access query, except that you shouldn't have any spaces in a field name, so call it "taxPercentage". If you can't change the name, then just put square brackets around it - [Tax Percentage]. Also, in Access the syntac is "IIF", rather than...

Hi there, I think the original reply should have asked you to do Abs(readingdate -Startdate). If you do a query of your table, with the addition of a calculated field for Abs(readingdate -Startdate), then taking the minimum value of the calculated field will give you the record you are looking...

Thanks Meltdown, that would work. I had it in the back of my mind, though, that there was somewhere you could specify a sort order. I can remember seeing it when using cross-tab queries - you could specify column headings and force them to appear in a particular order. But maybe that's the only...

Hello all. I have a table of 'issues' which can either be 'Resolved', 'Partially resolved' or 'Unresolved'. I've written a report to summarise the issue by their status, but the report is sorted in alphabetical order, so 'Partially resolved' comes first, followed by 'Resolved'. What I want to...

You need to do a me.refresh when you get back to the main form. Hope that helps, StepOne

You can use an Append query to do this. Regards, StepOne