Recent content by Jalnac74

i'll give this a go. thanks!

thanks. ive done that. your code was much neater!!

Here it is SELECT [Copy Of filterTT-qry].Day, [Copy Of filterTT-qry].lesson, [Copy Of filterTT-qry].teacher, [Copy Of filterTT-qry].room, [Copy Of filterTT-qry].lsa, [Copy Of filterTT-qry].class, [Copy Of filterTT-qry].subject, [Copy Of filterTT-qry].name FROM [Copy Of filterTT-qry] WHERE...

Hi, I am trying to filter a subform based on the values in 5 different combo boxes. The boxes can be empty or filled and can be any combination of the selections. I have the following but some of the combos don't generate a filtered list. To clarify, this query is based on another similarly...

Thanks Cronk, this is now working as I wanted it to.

Hi all, I have a form with a subform. On the subform I change the details in one field in a record and then want vba to change that field in other records where certain other criteria are the same (from other fields). I have managed all of this but then the loop doesn't stop. I have looked...

Hi, Stopher, I will try both of your suggestions. Once I have a workable solution I'll repost on here just in case others have the same issue. J

Thanks CJ and Plog. I thought that would be the answer but I wanted to check on the forum first whether it could be done in Access. I will have a look into exporting to an Excel Pivot table to get what I need. thanks to you both!

Hi all, I need to create a query/report that basically allows the user to see data where there are 2 header rows. something like criteria 1 a b c item 1 item 2 Does anyone know if this is possible? Apologies if the 'table' above does not look right, I'm not sure if it can be created on a...

Hi Ranman, this is great. This works with the first criteria only but I am now getting a Type Mismatch error when I have 2 criteria. I have printed the Sql string in the immediate window and get the result below. print sqlstr Select * From [caseemail] where 1=1 and [send stage id - current]=2...

Ah right, that is where the error has come from then. sometimes there will be a null value for one of the criteria. Is there anyway to write this code so that I can have one or both criteria selected and get the results I want?

No they are both numerical fields, the combo returns a numerical value...

Hi all, I have created a form which sends an email when the button is clicked. However, I want to use multiple criteria for an SQL string which selects the recipients of the email. Basically the end user selects criteria from one, two or three combo boxes with the idea that the SQL is build...

Hi GTH - I need to do exactly what you said in your OP but haven't got the faintest idea what most of what you said is....is there any free to use code that could do this for me?

Hi, When I started working with Access I downloaded a couple of examples from the web and had a look at how they were put together, what they did and any code/macros that were in it. You may not work this way but it certainly worked for me. J.