Search results

OK will look at it when I get back from holiday :) Many thanks in advance!

Not sure if that does help, the only one I think it might be is The fields in a JOIN are not indexed correctly: there is no primary key or unique index on the JOINed fields perhaps?

Hi James, Can you clarify what you mean by grouping? A bit confoozled :) Ruth

Hope this helps :)

Sorry I can't do that, hence why just pasting the sql. Ruth

Nope, the second makes reference to the query qry_ipptreatments

Hi all, I have a query which is working OK, but I want to add another query (the data needs to be in separate tables). This code works: SELECT tbl_patientdetails.[Patient ID], tbl_patientdetails.FirstName, tbl_patientdetails.Surname, tbl_patientdetails.NHSNo, tbl_patientdetails.DoB...

I completely agree regarding the Zen, I have a Zen Sleek and it's been awesome. It's still surviving several years later which in itself is testament to its sturdy construction (I'm not the most careful of people!) and it doesn't require some proprietory software, although you can use the Zen...

Hi all, I'm using tabs on a form, with each "page" having a subform - e.g. page 1 is patient details and has subfrm_patientdetails; page 2 is referrer's details and has subfrm_referrersdetails and so forth. These subforms are each based on an individual query (qry_patientdetails...

I am very much a geeky gadgety person where I can afford it - plus I love tinkering around with website which earns me a few pennies :) I do tend to do quite a bit of beta testing and like finding new applications and things to make life easier :) Ruth

Yay for expression builder - couldn't remember the syntax for this one but this helped me remember :D Ruth

Think I've figured this one out using some useful help files here: http://office.microsoft.com/en-us/access/HA010345581033.aspx#13

Hi all, I'm doing a report based on a query for samples taken at a GP surgery, and there might well be more than one sample for each patient. For the purposes of this report, I only want to show each patient once, but I DO NOT want to remove the other samples from the table. I am guessing...

I work full time and am also self employed .. what does that make me :o Crazy I guess! In the real world, I need to buy a house imminently and settle down, maybe even have a family. Doing that when self employed is just way too much of a risk (and a cost!) however my business (predominantly...

Very true, I'm off xmas shopping tomorrow, hoping to clock up a few miles!

Well we could start our own league table here ya know ;) I'm sure someone could knock up a fancy database! Ruth

Can anyone clarify this for me? Ruth

Or people might learn to accept that others have different views and opinions? :)

I am starting to wish I hadn't even posted this thread - it was not intended to be religion bashing or arguing what version of christmas is actually true or correct .... come on guys, lighten up!

Working in a building of geeks, we have a funky spreadsheet which converts our steps into distance taking into account whatever factors you have to account for, then averages it out based on the number of people in the team and so forth. Seems to be working pretty well, people are getting very...