Queries
in [Access]
|
Troubleshoot A Query I am using these 2 queries: CrossTab1 SELECT UnderlyingSymbol, Date, Sum(TradeVolume) AS [Total Volume] FROM BTA_Trade_20100326143051 GROUP BY UnderlyingSymbol, Date; TRANSFORM Sum([TradeVolume]/[Total Volume]) AS Expr1 SELECT BTA_Trade_20100326143051.FirmId, BTA_Trade_20100326143051.UnderlyingSymbol FRO... 30 Mar 2010 11:39
This query is typed incorrectly or is too complex to be evalua I surprised it gets even that far without a SELECT statement. If you have an issue with a query, it is customary to post all the SQL. -- Duane Hookom Microsoft Access MVP "GWB" wrote: OK - I guess the brackets are the problem.... it work now, but asks for the start time and stop time twice! Thank... 26 Mar 2010 15:37
using dates Part 2 Karl was great in helping me get to this point with dates, now I'm wondering if we can take it 1 step further? For Activity Dates prior to 2/1/2007 they are using a normal reporting year and the formulas below take care of Activity dates >2/1/2007? So for example prior to 2/1/2007 1/1/2006 would have a B_Qtr... 26 Mar 2010 14:22
turning off warnings in 2007 Hi, I cannot for the life of me find where, in a macro, to turn off the warnins. there was a SetWarnings command in 2003 that is no longer there. Can someone tell me where this is now located or how to do it? Thanks ... 26 Mar 2010 14:22
compare two tables for mismatch data I have to do a comparison of two tables. Both tables have the same exact headers. The first table is the standard rates template which is linked from excel. The second table is coming from a query off our AS400 system. So basically we are needing to compare with the standard template vs what was inputted in... 26 Mar 2010 12:00
Calculated Field in Query - Date Format I have the calculated field below in a query. I was expecting to get the results in the query (for this field) formatted as a date. But this is not happening. Can anyone explain why, and suggest solutions? Thanks in advance, Paulo Relevant_Date: IIf([Payment Terms]![Counting From]="Shipment",IIf(IsDate... 26 Mar 2010 13:12
fuzzy matching help please in an Access 2003 query I have two data files each containing phone numbers but in one file some of the numbers have text such as "home" as well as the numbers. Also one file has landline and mobile numbers separated by a /. I have set both of the fields I want to match as text rather than number. I think there is a way to match o... 26 Mar 2010 10:24
Autofill field based on a table of allowable values I have a form based on a main table of geographic features. However, for all new records, I would like to have the Geography Feature ID field autofill based on a separate table of allowable values. I would use the autonumber format for this, however, the allowable values are a list of letter codes (i.e. AAAA th... 25 Mar 2010 17:28
How do I display the most recent of three dates in an Access quer. How do I display the most recent (or latter) of three dates in an Access query? ... 25 Mar 2010 17:28
How do I show all characters before the letter A in a Query? I have a table that has a field which contains numeric and or alphanumeric values. I am wanting to develop a query from which the field "TAG" can be searched and for any records that has a letter A,B,C,D etc at the end, that letter is placed in another field. Example TAG Field1 Field2 020... 26 Mar 2010 15:37 |