Search results

hi, can commenting be done in access queries? if so how? Thanks, spec

Hi all, I had table with following data Table f1 f2 f3 1 10 AB 1 11 WW 2 10 DD 2 11 DD f3 is memo field I had to retrieve data by grouping records based on f1 value and i had to display f3 value as "-" if all f3 values for a f1 are distinct. If all f3 values...

Hi all, I had table with following data Table f1 f2 f3 1 10 aa...... 1 11 aaa... 2 10 bb... 2 11 bb....... f3 is memo field I had to retrieve data by grouping records based on f1 value so i gave groupby in totals section to f3 field also. I am getting the...

hi friends, I want to get year and month field of datetime field so that i can get data by comparing them with other table fields. ex: date field column contains 1/28/2005 as data how to get year(1/28/2005) how to get month(1/28/2005) expecting your help Thanks, Spec

Hi friends, I had two tables parent(f1) , child(f1,f2,f3). I had to display f3 value for parent(f1) when f1 has only one f2, if f2 values are more than one for single f1 and if all f3 values are 0 then i should display f3 as 0, else if some values for f3 are nonZeros and some are Zeros then is...

Hi friends, I had two tables parent(f1) , child(f1,f2,f3). I had to display f3 value for parent(f1) when f1 has only one f2, if f2 values are more than one for single f1 and if all f3 values are 0 then i should display f3 as 0, else if some values for f3 are nonZeros and some are Zeros then is...

Hi, I had a problem in appending data to table. I had to append Table1 data to Table2, and the condition is that i should not append the records if they are already present in Table2. How to do this? Please help, i am in urgent need for this. Thanks

I need to write a query which retrieves all the records from first table and those matching from second table and also satisfies a criteria. I had Table 1 F1 F2 F3 Table 2 F4 F5 F6 F7 I had to get all the records from Table1 and also those matching with Table2 So i did left join and getting...

Hi, Based upon the parameter given i want to run different queries i need to do the below in one query. PARAMETERS Proj Text( 30 ); If proj="All" Select * from TbProj else Select * from TbProj where Proj_ID=proj; I want to build an access query like above. I don't know whether it supports...