Search results

:banghead: Hello, I am writing a WEB Access 2010 application and I have just discovered that I cannot use a SQL SELECT statement within my Query. The SQL STATEMENT creates a new column called CondPrice within [CFLHPtbl] populated with a lookup and match from a comparison between [EQPPrice]...

pr2-ugin, The model# will always be part of the AHUCond1 column. The idoits that put the table together just through all the Air Handler Model (AHU) #'s together to save time. I need to seperate the fields so that I can tie pricing back to each model #. Please note that not all AHU's have two...

:banghead:I am trying to separate a random model # and move it to another column; example: AHUCond1 CHP1232CD6 MBV2000AA-1A CAP5454BD6 CAP4848DCD6 CHP6060BD6 GMV2451CDC6 The End Result should be: AHUCond1 BlowerMod CHP1232CD6 MBV2000AA-1A CAP5454BD6 CAP4848DCD6 CHP6060BD6 GMV2451CDC6 I...

I understand the Delete Query, however I am having a hard time figuring out how to do it in a Web Query. I have looked through the previous questions asked in the past but I can not find anyone that has run into this problem....Can anyone help me?? Thanks in advance!:banghead:

I am working on a Access Web application and I am running into a problem with the REPLACE Function. I am trying to replace a " * " in the second position of a model number: AHRItbl FurnaceModelNumber A*VC80905CXA* G*VC950704CXA* G*V950453B** G*V950704C** A*VC80703BXA* G*VC80704BXA* I am using...

Working on an Access Web application using Access 2010 and I can not get the Replace function to work in my Web Query....Not Happy!!!!