Queries
in [Access]
|
Ambiguous outer join I have an update query that joins three tables, A, P & S. S & P are linked with an inner join, P & A with an outer join from P to A. Each join is on three fields, none of which are common between the joins. The query works fine and displays fine in the graphic window, but throws an error message about "The SQL ... 26 Jan 2010 14:23
Nested views I read the following tweet on twitter. I have happily used nested views in MsAccess, but I have been dealing with dataset <100,000 records. Are nested views always "bad"? "Another happy client. Removed SQL nested views from an app and they can't believe how much quicker the app is running. Nested views are bad... 25 Jan 2010 08:19
Can not group on fields selected with '*' Trying to run an aggregate/totals query to group on a particular field but getting message...."Can not group on fields selected with '*' . And when I pick one field in qry all of the fields in the table show up in the View. Is it due to the relations? Thanks ... 25 Jan 2010 08:19
Sorting misc text into new fields if data exists in record update I have inherited a database where someone in their infinite wisdom asked staff to put four key fields into a memo field and separate them with a line break. I am trying to tidy up the field so that I can select the data (if it exists) into four fields: Date of payment. Net amount. Tax amount. Interest ad... 24 Jan 2010 11:20
Crosstab query... I am frustrated with this one... I have a crosstab query used to display results on a graph. I want to filter "risklevel" depending on what is selected in a combobox using a value list. When I put in the filter and run the query, I get the error "The Microsoft Jet Database Engine does not recognize [Forms]![frmLO... 24 Jan 2010 00:21
Query input value to determine another field results In the below query I want the max year field to pich the associated school that the coach was affiliated with that max year. Currently the query gives the last year that the coach coached and the highest alpha Name of schools - which not what I want. Example: Coach Year ... 23 Jan 2010 17:43
update two fields at once Hi Access Gurus, In A2003 I want to write an update query which updates about ten fields at once. The idea is that if any one of these fields is null, I update it with a value read from a linked Excel table. For the sake of simplicity, let's say I have only 2 fields, F1 and F2. Either one of them might hav... 23 Jan 2010 16:35
FUNCTION PREDICTING EVEN/ODD COUNT IN QUERY Hey, I have set of queries in access which determine the following: Query1- Group single occurance together. Query2- Group all 2, 4, 6, 8, 10, 12 occurances together. Even occurance. Query3- Group all 3, 5, 7, 9, 11, 13 occurances together. Odd occurance. Union of Query1 and Query3 gives me the desired table... 23 Jan 2010 06:35
Date format Greetings, I am putting thisinquery because i think I will have to use a query to get my result. I need to export an Accwss 2000 table to mySQL. The table has a field that is a date. Access uses 12/24/2010. mySQL uses 2010-12-24. I need to change the Access table before I import into mySQL. Does anyone know haw t... 23 Jan 2010 08:45
round to nearest 5 How do I round a number to the nearest 5? 121.23 = 120 123.45 = 125 1456.19 = 1455 Any suggestions? ... 23 Jan 2010 12:05 |