Search results

In a table each record has a set of 12 checkboxes for recording different types of issues. In a report, I want a field within the main body of the report that is a count of how many issues (checkbox checked) for each record. Can anyone give any advice please?

:banghead: Lol...I said I was having a bad day. Thanks for pointing that out.

Sure...here's the SQL. I want to lookup the value in Team field in the FOSListT table that corresponds to FOS field in LocationImprov query.

Thanks but I'm still confused. If I want the query to return the value of FieldB what would I write instead of 'someTextValue' or instead of [myQueryField]. I'm probably being thick :(

I have a query in which I want to put a Dlookup expression but can't seem to get it to work. One of the fields in my query is FieldA. I want to lookup the value of FieldA in TableX and return the corresponding value in FieldB of TableX. Both fields are text fields by the way. The only help I...

Changing from "Yes" to True worked. Thank you, as ever.

I'm attempting to create a query field with an IIf expression to lookup three checkbox fields for their value and if the value is "No" in all three fields I want to return a question mark "?" but it's resulting in a syntax error. It appears to be an issue with the whole expression because...

That did it! Once again, thank you so much for all the help you've given so far. It's been invaluable. Thank you.:)

As ever, you've been most helpful, thank you. I've created this as a separate module and called it in a query using the date parameters from my form and it returns the correct result. However, the format of the date appears to be "forced" into dd/mm/yyyy. I've entered my preferred...

I unfortunately wouldn't have a clue how to do that as I don't even know which of these declarations is referencing the string fields with my extremely limited knowledge of VBA. I basically want the module to check exactly the same number of fields, for the same reason, for the same result, but...

I know I'm resurrecting this after a couple of weeks but, I'd like to know, if this module would/should also work with a date fields. I've tried calling it to check date fields but I receive a type mismatch error and the debugger gets "stuck".

Just re-read my original post and not sure if I've explained correctly. Basically, on the report, if the value is No in certain fields, I want it replaced with a blank ("")

In Detail of the report? I just tried it and it didn't work. That statement also doesn't appear to allow the Yes values to be visible on the report, or maybe I'm missing something?

I have a query and a linked report which has Yes/No fields from checkbox fields. What I want to do, if at all possible, on the report, is hide the No values from being visible on the report. I still want the other fields of those records with No in that field to show (so just adding Yes as...

The problem is that I have to have a historical record of issues recorded, even if they've been resolved, for quality purposes. I think I've solved it by doing individual queries for each issue. Thanks all for input.

Lol, sorry for the confusion. I have in fact multiple fields that are similar but for ease of example I'll just say four fields. On the form they are checkboxes. Field A is checked (TRUE) to identify a particular issue has been identified with a product, and Field B is checked when...

I want to add criteria to a query where if field A is TRUE and B is FALSE the value/result is TRUE. I'm sure this is easy but...not for me :/

Managed to download it and implemented it in my db and it works a treat. Thanks for your help, again.

Ummm, can't open the attachment because it's a .php file?

I've attached it. Data table is the test table and this works fine with the query. However, when I amend the query to reference my table Doc1 it doesn't. The "Referral" fields have been renamed for simplicity for the example to R1, R2 etc.