Queries
in [Access]
|
Right-Align Field When Exporting to Text Is there an easier equivalent to the "xg_lPad" function in ACCESS 2007" to right-align text in a field when doing a query? That function worked with ACCESS 2003, but does not work when using ACCESS 2007 with the 2003 database. -- JL ... 22 Jan 2010 20:51
Update query Hi All, How do you update different values in different cells with differnt values?. Thank you in advance. Thank you John ... 22 Jan 2010 21:58
Need to be able to see the PROPERTIES of a query I would like to (as in previous versions) be able to see the "properties" of the query. I have found the only way to see the "properties" is to right click and choose properties. Is there a way to show "properties" in the query view? ... 22 Jan 2010 20:51
Query - How can you string to fields together I have crated a parameter query where I have a last name field and a first name field from the same table, and want them strung together to be shown like this Doe, John. Does anyone know how to accomplish this? ... 22 Jan 2010 14:06
Data Type Delimiters Which data type delimiter would you use to express "Since Then/" ... 22 Jan 2010 14:06
Group By Query Hello I'm struggling to explain this but here goes. I have a table which contains 6 fields which make up the location, 1 field which gives the type of recording and 1 field which gives the date of the recording. Lets say there are 3 types of recording so I have 3 records for each location. I'd like the quer... 22 Jan 2010 11:50
Inline comments in Access queries How to add inline comments to access queries.? ... 22 Jan 2010 00:45
jeramie bellmay jeramie bellmay subed going to jail katalyst jeramie bellmay myspace-myspace.com jfie eye ... 21 Jan 2010 18:04
Help with "IIf Could anyone help me with this formula? I need to know where to put the coding that if there is no value in the selected txt's to return a zero. =IIf([costcode]="013210" And [costtype]="05320", [txtEstimatedCost]/[txtCraftLabEst], IIf([costcode]="020110" and [costtype]="05320",[txtEstimatedCost]/[txtFirewatch... 21 Jan 2010 18:04
Adding Sequential numbers to a new feld in access table. I am working with a table which is actually a merge of 14 other tables, therefore there is no real index key. Table 1 Index was 1-5000 Table 2 index was 1-5000 In the merged database there are about 52,000 records, but no index key. I added a field to the table named Index and would like to populate that f... 21 Jan 2010 19:12 |