Recent content by spec

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

you almost got it f1 has distinct f3 values in the example you mentioned. if distinct values are there then f3 value should be displayed as "-" otherwise if f1 has same f3 values then the value of f3 should be displayed. so for the example you mentioned the output must be f1 f3 1 -

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 got where the problem is , Null values are present for F6 and F7 so i am not getting the records which are not between F6 and F7.

Thanks Wayne. I am trying to do so. But not getting all the records. I think i am doing some thing wrong. Could u please give me the query. Thanks, Spec

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...