Search results

Is there a work around? Thanks

I've added 'Nz' to the query and now Excel is throwing an error "Undefined function NZ in expression". The query executes fine in Access. Do you have any suggestions how to fix this problem? here is the query: TRANSFORM Nz(Sum(graph_variant_final.AF))+0 AS SumOfAF SELECT...

Hello, I have code in Excel 2016 that executes a Crosstab query from Access which works well. However, I'm concerned what would happen after I split the database. Since all the queries will be in the front end, should I reference a read-only copy of the front end where the query is located...

I removed the two extra )) and it worked great. Thanks

Please help fix the following query so the criteria is applied. Currently, the criteria is not working. SELECT tbl_Projects.run_type, Count(tbl_Samples.sample_id) AS exp FROM tbl_Projects INNER JOIN tbl_Samples ON tbl_Projects.run_name = tbl_Samples.run_name GROUP BY tbl_Projects.run_type...

Please help to figure out the proper use of quotes in the following Dlook-up query: MetDNA: DLookUp("[tbl_Variant_qry].[gene]","[tbl_Variant_qry]","[tbl_Variant_qry].[sample_id] = '" & [sample_id] & "' And InStr([tbl_Variant_qry].[gene],"MET")>0 And InStr([tbl_Variant_qry].[exon],"14")>0") Thanks

https://bytes.com/topic/access/answers/891018-concatenate-function-query-struggling-character-limitation This solution is not simple but it works.

Without setting focus on the main form. Thanks

Hello, Could someone here suggest a better way of moving to next record on a main from from a button on a subfrom? The following code works but is there a better way? Thanks [Forms]![frm_sample_gene_panel]![frm_Change_Gene_Panel].SetFocus If...

I found a solution how to overcome this issue.

I've used Allen Browne's ConcatRelated function combine records with the same id from a table and to display them in a textbox on a report. This method has a 250 characters limit and cuts off some of the records. Is there another way to make this work? Thanks

Hello, I’m using Allen Browne’s ConcatRelated records function in Expr2: ConcatRelated("Exp","amplicons_failed_amps_with_depth","[sample_id] = """ & [sample_id] & """") to list records on a multi-page report. Each page pertains to a different record. The limit is 255 characters and the rest...

What will be faster once I have lot's of data in tables, filtering the form or using the query? Thanks

Please see the attached db. I was hoping to use "Load Form" sub which used the query and is much faster than filtering the form but passing the parameters between dates is not working. Thanks

That didn't make a difference it still throws the same error if I try to save the query. I have Access 2016. thanks

I get "expression you've entered contains invalid syntax. You may have entered operand with operation." >=[Forms]![frm_search_comments]![txtStartDate]And < DateAdd("d",1 [Forms]![frm_search_comments]![txtEndDate])

Sorry, but Access tells me the syntax is invalid.

When I type this as criteria for one field I get a message that the expression might be typed incorrectly or too complex. >="#" & Format([Forms]![frm_search_comments]![txtStartDate],"mm/dd/yyyy") & "#" And <="#" & Format([Forms]![frm_search_comments]![txtEndDate],"mm/dd/yyyy") & "#" it didn't...

How to correctly format date values in query criteria? Thanks >=Format (#[Forms]![frm_search_comments]![txtStartDate]#, "Short Date") And <= Format (#[Forms]![frm_search_comments]![txtEndDate]#, "Short Date")

The same result, no data is shown when the form loads. When I try to enter values into the fields and reload the form I get: "You've entered an expression that has invalid reference to the property of Form/Report" Does this have anything to do with the field type? The form has a short date...