Search results

Here is one approach you could use:SELECT tMain.YearNum, tMain.SchoolID, tMain.NumberFld, (tMain.NumberFld)/(tSum1.SumNum) AS NumRatio, tSum1.SumNum AS CurrentYr_Aggregate, tSum2.SumNum AS PriorYr_Aggregate, tSum1.SumNum - tSum2.SumNum AS Aggregate_Diff FROM tbl_Aggregate_Test AS...

Depends... I'm assuming you're referring to panel 'tables' rather than 'databases'. If each table has the same structure and same # of fields, and each of them have the same field names, then it would probably make sense to create a User-Defined Function (UDF) in VBA. But if the table...

NP - and just to mention, when you condense all your Modules into a single column, it usually helps to add a corresponding column "ModuleType", so you might want to consider adding that column to the new table structure. HTH, John

It should not be prompting you for a parameter value. Is "Panel_ID" the name of your 'Product' field and is it spelled correctly everywhere it occurs in the query?

Hi bladu, You might want to try this modification of your mysql query and see how it compares to what I originally suggested: SELECT DISTINCT C1.Revision, C1.Fecha_ult_revision FROM Control AS C1 INNER JOIN Control AS C2 ON C1.Revision < C2.Revision AND C1.Numero = C2.Numero AND...

Hi bladu, Using the other operators in JOIN expressions is certainly possible and allowed in Access, but this simply limits you to using the "SQL View" rather than the "Design View" (for some reason they haven't developed visual representations for these types of joins) The SQL solution you're...

You're welcome Dave :)

Depending on how you determine a unique record, something like this would be one approach to use:SELECT T1.Revision, T1.Fecha_ult_revision FROM Control AS T1 LEFT JOIN (SELECT TOP 1 * FROM Control WHERE (((Control.Numero)=[Num]) AND ((Control.Hoja)=[hoj])) ORDER BY...

Hello and Welcome! First point, perhaps you're already realizing - you don't want to store the data according to how your Table Two is setup. To convert what you have stored already you can create a UNION query: SELECT PartField1 AS PartCode, Product FROM [Table Two] UNION SELECT PartField2...

Is this what you're looking for? - Criteria for Column 1: Like [Column 2] & "*"

NP - I'd also remind you not to forget the advice from HiTechCoach (note, I had to edit the placement of the final double-quotation mark to be after the blue parentheses)

Try: =DLookUp("[Dummy]","tbl_main"," [type] = '" & [cbotype] & "' And ([refNo] = '" & [cborefNo] & "' Or [refNo] = '" & [txtrefno] & "')")

NP - presuming I've hit on the issue, just keep in mind that the parameters used to feed your query will need to come from an external source or value list - such as a selection from an unbound combo box or list box. Hopefully if you get your db producing some useful results, "Big Brother" will...

I just had a thought - The behavior is symptomatic of circular reference behavior. And if we consider that the RecordSource for your form may be based on the query "AssetListFilter", then we do indeed have a circular reference. In other words, we can't be loading the form's RecordSource and...

Hmmm... this one's a stumper! Well, as an alternative, you could move the text box (cmd_TotalAsset) to the Header or Footer section - then change Control Source to = Count([Asset]) and see if that gets you what you need...

what happens when you change the WHERE clause to: WHERE [Asset] = [Forms]![frm_AssetsUnderMan]![Asset]

boomslanger, just to update you, I had a go at setting a DCount Control Source on a text box and I was unable to reproduce the behavior you're experiencing. While the value temporarily disappears between record moves, it otherwise persistently displays without any manual refocusing or cursor...

Re: Creating Listbox into "search form" that generates query - see code - almost ther NP - best wishes for your project :)

Re: Creating Listbox into "search form" that generates query - see code - almost ther just create a "For Each varItem In ... Next varItem" loop for each list box (if it's not too many list boxes)

Re: Creating Listbox into "search form" that generates query - see code - almost ther strSQL = "SELECT * FROM Master WHERE " & strCriteria