Recent content by bmcd
-
B
Query with complex joins (sub-query)
I need to execute a complex query. I can get the query to work if I break it into two queries, queryA and queryB, and then use queryB inside queryA. Note that queryB (combined query) produces the final results I want. Here is the code for queryA --------------------------------- SELECT... -
B
Totals Query Problem
I want to do something fairly simple. I have 2 tables that are structured as follows: Table_FormLogInfo (Table #1) ------------------------------------- ID AreaID FormReceived ReceivedDate * Note that the field "FormReceived" can be set to 1 or 0. Table_AreaAbbr (Table #2)... -
B
Form/Subform Linking Problem
I'm having a problem linking a form with a subform. I have a simple database that is broken down as follows: * 3 tables (TableA01, TableA02, TableA03) which are all related as one-to-one tables * 1 table (TableTM) which is related to TableA01 as a one-to-many I have created a query... -
B
Setting Field On Subform to Same As Form
I have a main form and a subform. The records displayed in the subform come from a query. My problem is related to when the subform is initially empty or when the user is creating a new record. There is a field in the subform called SiteID and there is also a SiteID on the main form. When...