Code:
select distinct (cars) from tbl1, tbl2 where tbl1.col1 =tbl2.col2 and tbl2.col2 is not null and tbl1.col3 not in (1,2,3,4) and tbl2.col4 = '2013.09'
baba
Last Activity: Feb 1 '13, 01:05 AM
Joined: Nov 15 '11
Location:
-
How to get 0 from a query when no data is found for a criteria
Hi, I am trying to run the below query. It fetches records when the select criteria is satisfied, however when no records are matched, I would like the query to display 0 .Please help!
Thanks ! -
Msaccess query to update only day part to 01 in date field
Hi, I have a date/time column in msaccess 2007 table and it has values in mm/dd/yyyy format. I want to keep the mm and yyyy values as it is and only update the dd value to 01. Is there an easy update query to get it done.
I am tring to run a query like this
However I am getting a syntax error on Update statement:Code:Update Table1 Set Day(ColumnName) = '01'
Current value example : 01/23/2012... -
Can I change Month(Now) date only within MsAccess 2007 DB
Can I change Month(Now) in Msaccess to point to someother month without changing the system date in the taskbar date/time settings of my computer.
In otherwords,is there a way to change the date/time settings to affect only MsAccess DB without affecting other documents.
I am using the below query and I want to control Month(Now) to point to a month of my choice rather than taking the system month/date.
... -
How to display page header of subreport in the main report in MS Access2007
I have 5 subreports subreport1 to subreport5 in the main report's report header section.
How to display page header of subreport3 in the main report. Please help !
thanks -
Table column data in a report
I have a table with one row and 5 columns. How to display column1 value in the text box of report 1 on opening the report1. -
How to display form data in a report after closing the form
User enters data in a form (Form1) ,textBox1 and clicks save button and closes the form.
The user then opens Report1,while opening the report, the report should show the form's text box content in the reports textbox. Is that possible. Also can I retain the same data in the report till the user once again opens the form and changes the data. -
Row level condition formating based on column value
Hi,
I want the entire row color to change based on a column value in a report.
Foe example: Select Name,Age,Salary from table 1 -cretes 3 rows.
Name Age Salary
A 15 1000
B 25 2000
c 35 3000
First row should be in red if Salary column is less than 1001
Second row should be green if Salary column is less than 2001.
Third... -
How to add my own rows to a query in MsAccess using Union,Dual Table
How to add my own rows to a query in MsAccess ?
I would like to do something like this:
Select Name from Table 1 where age > 75
Union Select "Joe" from Dual;
Expected Result: If Joe is not found in Table 1 ,then it would be added to the result of the query.
How can I do it in MsAccess as it does not use " DUAL" table. Thanks for the help! -
How to draw graphs using query and open the form in pivot chart view using vba
I am using this statement to open a form in pivotchart view.Code:DoCmd.OpenForm stDocName, acFormPivotChart
Also, in the pivotchart view of the form,I dragged the columns that I needed for the graph and when I close the form and reopen the same form with a button click,the form opens up with empty barchart in pivotchart view. Is there a way to populate the graph based on the query while the form is opened in pivot... -
How to open a report in pivot chart view by default in MSAccess2007
I like to open a report as a pivot chart from my query.
How to open a report by making the default view of report as pivot chart?.
I am able to manually create a pivot chart by clicking pivot chart view from the sql view in a report. Then I pull in the required columns to the x axis and y axis and a graph is generated. I do not know how to save it and open the report by default in pivot chart view every time I click a button. -
I have no clue if there is an option to change the format of the legend to text .So I reformatted my data and prefixed my data with a colon and by that it forces the data as text and 0004 is written successfully as :0004 into the legend. There may be other solutions but this works... -
Hello ,Thanks for your response. I am unable to change the format property of the legend object to text .I would really appreciate if you could explain me the steps involved. I dont see a format property for legend at all. Also even if I change the column to text in the datasheet and rerun the query,the legend does not show the leading zeros in the bargraph. Please adviseLeave a comment:
-
MSACCESS-Piechart- legend -truncates zeroes
My legend in the piechart has values like 004,008 etc but while the report is created,the legend has the preceding
0's truncated and 004 is shown as 4 and 008 is shown as 8. Is there a way to fix that and avoid removal of preceding zeros in the legend. Thanks for the help ! -
How to increase report header height in MsAccess
I am creating barcharts in the report header section but i think there is some size restriction and I am not able to add more than 3 graphs in the report header section. I have to add 65 graphs. Is there any way to increase the report header height. Please help !!! -
MSAccess query barchart color
SELECT TrendRemedytbl.[Job Name], Count(*) AS [Count]
FROM TrendRemedytbl
GROUP BY TrendRemedytbl.[Job Name];
This query generates a barchart with jobname in xaxis and counts in yaxis .
Can i also get the color of bar populated CORRECTLY based on if conditions within the query
I want something like what I have pasted below but the syntax is incorrect. Please help ...
... -
MSAccess-barchart-colorchange based on xaxis value in vba
Query ran to create barchart :Select jobname,count(* ) from table 1;
In my bargraph,
X axix shows jobnames.
Y axis shows counts.
All the bars in barchart are of same color.
Currently the generated bar graph shows all jobs joba,jobb,jobc, jobd in the same color.
My requirement:
Is it possible to write some code like this to change the bar colors after the bargraph is generated...
No activity results to display
Leave a comment: