Search results

Well, I've found what is as close to a solution as is possible here. What I'ave had to do is set an aggregate function to choose the subscriber status, and hopefully this won't have to many bad side-effects later on down the track. This lets me group by the single table and not need ot worry...

Even with the "HAVING" set, I still can't get around the GROUP BY statement requireing that I group by tblTicketType.TicketType_subscriber and that is where the duplication issues with this query are coming into it. Not sure if that's a bit better explained or not. :confused:

Is it possible to use HAVING and WHERE together? What I've given there is an extremly cut-dwon version of a dynamically produced query that I have a field with around 17 different fields that could possibly be searched through. Unfortunately, the "TicketType_subscriber" is only one of those...

Hello all. I've got the query: SELECT DISTINCT tblCustomer.Customer_id, tblCustomer.Customer_firstName, tblCustomer.Customer_lastName, tblTicketType.TicketType_subscriber FROM (tblCustomer INNER JOIN tblAttendance ON tblCustomer.Customer_id = tblAttendance.Customer_id) LEFT JOIN tblTicketType...

This is a pretty open question. Here's a few things that we'd need to know before offering advice... 1. What type of database is it? Access, MySQL, SQL Server, Oracle, etc? 2. What type of server are you running on? Linux, Windows, etc? 3. What level or programming experience do you have...

Looks very good Moniker. I did try searching for this thread, but I'm thinking that my search terms weren't as good as yours (I never even knew that existed). I'll give that a go too and see how that works!

Not sure if anyone else has got any ideas, but I "seem" to have almost solved my own problem. So far at least. What I've done is ssaved the Word document as a Rich Text File which still retains the formatting (so far at least), there's no hassles with the binary way that Word saves it's files...

I might not know much about Access, but I've been a Mac user for YEARS. Access will NOT run on any Macintosh computer using the Macintosh OS. As far as I know there's no programs that can have it work on Mac's so you will probably be out of luck. FileMaker is the "default" database program on...

Hi all, I seem to have had a very small "breakthrough" with another problem that has led me here. What I'm trying to do is somehow get a 12-page Word document to be almost "mail merged". There is only going to be one done at a time, so it's not a real lerge job. What I'm trying to do is read...

Have you tried to do anything yourself so far? If not, it's a big ask to tell people on here that you want them to do it for you. Post what you've got there so we can have a look at it, and let you know what can be done to change it to work. See, Access is a weak point of mine. PHP and MySQL...

I've tried the sub-pages, but they have the same problem with not letting the length of the entire report go over the maximum length of 22", so no matter what I try and throw in there or how, it always comes back to that hard limit. The sub pages also have other problems as far as consitant...

Yep, that would be good. But... :confused: I have got no idea of where to start even looking for that. Any ideas would be greatly appreciated.

The Mail Merge is a good idea, and one that I thought of myself. But, there's still issues with that. The main one is that each application can have multiple applicants, so each applicant needs to be listed on the one bill of sale document. To complicate matters even more, each applicant may...

Hi all. I've just been handed a new project here and it's all involving Access (which I have had very little exposure to in the past). The problem that I'm having is that the customer wants a new form put in as a "Bill Of Sale". Getting the values for this is no problem, but the bill of sale...