Search results

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

dats good enough. i just have to push a button and have the latest data. if i use the append method, i will have to keep appending every time there is a change and i may get lost with so much data involved. so i hope to be able to use the union i am going to shorten the alias and also try the...

oh my! i actually thought it works like join queries which auto update you mean assuming i do not add any additional column and if i change the value under a fieldname ..say, from 1,000 to 2,000, in the linked tables(whcih the select queries are created on) and i double click on the union...

hi MSAccessRookie, thank you for your advice. i will change the alias to a shorter form as you suggested (SA for Scenario A, SB for Scenario B..etc) and hope it will work out On your other suggestion, do you mean i have to just type in the fieldname without copying/pasting the entire SQL .. so...

yes, i saw the advice from MsAccessRookie. I will try the shorter alias method that was advised yes i thought of appending the queries. but the issue is there will be sunsequent updates to the data (thats why i used linked files to excel spreadsheets in whcih the data will be uppdated) and i...

thanks. its much clearer i have to admit. yes all these queries are created out of linked files and i need to identify the data specific to each linked file so i created the expression column named "Scenario A", "Scenario B" ...etc before attempting to combine these together. the key idea is...