Search results

I have a column name priority, in this column, the data consists "Very High, High, Medium, Low and etc" how can i make a order clause acording to the Priority level? i found from this from net, but is only applicable in SQL server... how can i modify this to suit mine? SELECT * FROM TABLE...

How can i insert a single quotation ' or double quotation " to the Ms Access database?

Is it possible i create one master table and link few table together?? In the mdb that i attached there have 3 table - tblMaster, tblConfiguration1 and tblConfiguration2. Using the relationship to link tblMaster's field Configuration to other 2 table Configuration field but there only showing 1...

i would like to querry a date which only showing work week and year... i try in FORMAT([MYDATE], 'WW YYYY', 1, 2)... it work but when go to 31/12/2006 it showing "01 2006"... but suppose it should show "01 2007" how can i overcome this?

there is a end_date column record with date/time datatype, how could i query datat that showing the particular is empty. i try end_date = NULL, no record is showing and end_date = ' ' , datatype mismatch... so which one should i write??

if the beween statement is use as "number between 1 and 7" so record with number 1,2,3,4,5,6,7 will be showing right?? but what if using in date?? example mydate between #04/01/2006# and #04/05/2006# the record i aspect is 04/01/2006, 04/02/2006, 04/03/2006, 04/04/2006, 04/05/2006 but it just...

How can i get the count of date inside a database. the date might be duplicate, so i would like to know how many days are in the table. i try in this way... SELECT count(distinct( format([mydate],"dd/mm/yyyy"))) as DayCount from tbl but error message "undefined function 'distinct' in...

I got a problem regarding query work week in database. The database contain data of year 2006 and 2007. When i query about work week, some record is missing. i wrote the sql statement as SELECT * FROM TBL WHERE FORMAT(MYDATE, 'WW', 1, 2) = 1 AND YEAR(2007); There is one record missing... which...