Search results

using sql or access query I would like to create an expression that aggregates the first field and I would like to see all records grouped by the relationship with another field. Let me show an example. My query shows: field1 field2 apple a apple b banana a carrot a carrot b dog b elephant b...

Hi I'm working with a main form and subform with 3 combo boxes that control the records and vba to control record sources. If the combo boxes select a combonation of criteria for record does not exist in the query. I get error 2455 see image below. I can bypass this warning with error...

Here are example of my tables: one-to-many tblNames-tblAssets one-to-one tblName-tbl General tblNames ID Name tblAssets ID Quarter Year Assets tblGeneral ID Address Phone I have multiple data for names on assets, for example, ID "1" has assets for Q1 2012, Q2 2012...Q4 2013, etc. I...

Hi, I am relatively new to Access, I would like to format a date field as a quarter in my query. Not sure how to build the expression. Thank you.

I constructed a loader from Excel 2007 into Access 2007. Working in VBA for Excel, the macros finds the database in the same folder as the Loader. Everything works fine on my desktop, but when I am working from a shared network drive I get an error on line: "rst(Cells(1, j).Value) =...