Recent content by jvbeats

solved. I needed 3 queries. I first generated queries with unique records for field2 criteria: "a" and another for "b", then joined them on an intersect distinct in the third query. this was very helpful http://www.gplivna.eu/papers/sql_set_operators.htm

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...

thank you. solved.

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...

Solved this on my own. The code is good, just needed my data and update tables to be different otherwise the connections were conflicted.

Sorry. I think what works best is Format([mydate],"q")

Where do I put this expression?

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) =...