Queries
in [Access]
|
How do I bring a filed from multiple records and join them tog This uses 2 tables, is it possible to use the function with a single table "Marshall Barton" wrote: Dave wrote: I have a recordset that has a common identifier with comment information on multiple lines. I want to create a query that diplays the multiple lines in a single line. I will send t... 14 Apr 2010 18:57
How to calculate average for current quarter? Hello, I have a table with field Year, Month, date, model, value. What would be the formula to calculate the current quarter average for the different model? Sample: Year Month Date Model Value 2010 1 1/1/10 A 20 2010 2 2/1/10 A ... 14 Apr 2010 16:42
Format for text field Hi- I have a text field, the format of this field is ##.## (ex: 09.10) How can I check this field if it have a value then it must be in a format like above? (null is OK) Thank for any replpy. ... 14 Apr 2010 21:11
Querying for Extended ASCII Characters I have an imported flat data file that has extended ASCII characters (i.e. 189, 239 and 191) in a Customer Name field. The extended characters are not always in the same location of the Customer Name field and are not always the same extended ASCII characters. My question is there a simple way to query for ex... 14 Apr 2010 14:28
dynamically choose columns in query I'm trying to create a query such that when the user runs it, the proper columns (fields appear). We have 12 columns, one for each month of our fiscal year (which goes from July to June). Basically, we run the query once a month. When we run it, for example in April, the months prior to April & including Apr... 14 Apr 2010 14:28
parent child link query I have a query which has a parent and child link tables and would like to have all the records in the parent even no child for this parent. It seems MS Access gives the link only the parent has child. I try to use outer join, but MS Access gives me it contains ambiguous outer joins. Any information is great ap... 14 Apr 2010 14:28
Query Criteria issue Access 2003: Trying to create a demographics report that will allow the following. Gender example On the form "frmStudentDemographics" is a drop down field named "cboGender" When the user makes a selection "Male" a report is generated for only Males. But in some cases the user will want to run a report for bot... 16 Apr 2010 10:35
How do I bring a filed from multiple records and join them togethe I have a recordset that has a common identifier with comment information on multiple lines. I want to create a query that diplays the multiple lines in a single line. I will send this off into another table. So... ID Comment 123 Hello 123 Dave would equal 123 Hello Dave ... 14 Apr 2010 21:11
Combining Dup Info I have a table (tbl1) that has Invoice # and Item Desc as Fields (the info i used is fictitious) : Inv # Item Desc 50014 Cheetos 50014 Gum 50014 Cigarettes 61032 Candy 49544 Soda I have another t... 14 Apr 2010 21:11
Date expression in Query I am getting 'undefined function' w/this expression in my qry. Expr1: IIf(today()<[PoP_End_Dt],"cur","exp") How do I insert or use todays date in a Query. ... 14 Apr 2010 14:28 |