Recent content by graveyard

hi ppl, i have been tearing my hair apart over an issue i have been trying to fix for the past 2hours I have a database in whcih i changed the fieldname. subsequently i changed the field for all the queries but i ran into problem with one of the query that contains this fieldname. suppose i...

Thanks Sam! Its resolved!

That does it! Thanks so much, plog for your help! :D

hi Sam, thanks for responding. pls find attached database2.mdb. If you look at the query, i have a calculated field called "Extract" and this has to JOIN with [Year] field of table2 in a single query. in the query, there was no join because i dont know how to create a join btw [Year] and...

hi plog thanks! I entered below based on your statement. SELECT TABLE1link.*, ConsolREF(2013AOP).* FROM (select *,left([period],4) as linkData from ConsolAOP) AS TABLE1link INNER JOIN ConsolREF(2013AOP) ON TABLE1link.linkData = ConsolREF(2013AOP).Period1; where ConsolREF(2013AOP) and...

Dear all, i have a question on subquery on calculated field. i have extracted the first 4 letters from a field to form a lookup id [left(A,4)] = Y (end results of the left formula). in the same query in design value, i want to join Y to another table (let's called it TABLE2) that has the same...

thanks Bob! Will take note of the format requirement - i dont have the full date here. Nevertheless, monthnumber advised by john fixed it. :)

Hi John - thanks! Works totally!! :D

hi people, I have a pro with a form that is supposed to show the month name when user query data by inputting month number (1= January, 6 = June etc). i set the control source of the text box (that is supposed to display the month name) as =Format([Forms]![Cover]![MonthNum],"mmm") where...

hi Bob, thanks. that fixed it. Thanks again for your usual great help!

Hi guys, I have a vba to auto export access data to excel. the function 'SendTQ2XLWbSheet' is activated by an access macro. There are many workbooks to be exported to and each has 2 tabs "Sheet1" and "Sheet1". I save these files with "sheet1" view (so when i open these files, it will be on...

Anyone pls?

i wish to clarify that i could do following: Diff:[Table1].[XXX]-[Table2].[XXX] but i got easily 40 fields to perform this. so i tot it will be good if there is another turnaround

Hi everyone, i have a query. how do i subtract numerical values btw tables? pls look at the atatched file. i have 2 tables (Table1 and Table2) with several fields [ABC], [XXX], [YYY] .... in both tables. i need to subtract the values under these but i need to get what is displayed in Query1...

hi vbainet, i tried MsAccessRookie's query method but got the same error - system resource exceeded. i didnt change the alias name but i m gg to do it now. do you know if this will make any difference in terms of getting the query streamlined and produce results .. now that i am using "select*"...