Search results for query: *

Hi all, I have a table, myTable, sorted properly by PROVINCE, POSTALCODE and AREACODE. The last field in the table is FACTOR field. I need to create a query that will create a running product based on area code. Note that the count has to restart each time we have a new area code. Any help? Thanks!

Hello, I have a query, say [myQuery]. And I composed an SQL string myString. Is there a function to change the sql code in myQuery to myString from whatever it is now programatically. I am aware of CurrentDb.CreateQueryDef(), but this function creates a new query, I just need to change the sql.

Hi All, How would I refer to the element in my field on the previous record? Say I want to multiply the value of field [factor] by the value of the field [factor] in the previous record?

Hi I have a table of this kind: ID | Hair | Eyes | Shoe Size | Factor ------------------------------------------ 1 | Blnd | Blue | 11 | 1.2 2 | Black | Green | 9 | 1.9 3 | Brown | Hazel | 10 | 2.1 etc What I want to do is have a crosstab query, that will...

Hi, I have a table that has a field that contains spaces. I would like to remove all spaces from that field. Is there a built in function in Access to do that in a query? Eg: I have: "this is an example" I want: "thisisanexample" Thanks!

Hi Is there a function I can use to find the numeric remainder of a division? Something that corresponds to mod() in java. Say I divide 11 by 3: I want to get 2 11 - 9 = 2

Hi I have a select query that's using an oracle linked table and joins it to another query by memberId. When I try to sort the results, the query freezes or populates with N/A's. I have to do it in two steps for some reason. Does anybody know why? The tables are rather small (couple of...

Hi, I have a table with cashflows that go for 100 years across (I know Excel layouts are not fun). I imported it into Access. I have the following fields: StartYr,Y1,Y2....Y100 In the Y1, Y2.. columns we have amounts that the cashflow takes, interest rate varies a lot so I can't re-calculate...

Hi I have a listbox in one of my sheets, it keeps shrinking every time I reopen my workbook and I have to expand it manually. It's VB code generated (every time I load the workbook the values are being sent into the listbox). Any ideas how I can lock the size? I know how to do it in Access but...

Hi, I inherrited someone's spreadsheet with a listbox in it. How would I check where the listbox is reading from? I tried to do Design->Properties but no luck there, also tried to look in Format Controls and still nothing. THNX!

Hi This is driving me nuts I am picking up first letter of the clients last name field: FL: Left(LAST_NAME,1) Why do I get a compile error on this line? I've written 100000 Left queries before. SO frustrating.

Hi I have a VB string myString that contains some SQL code. How do I create a query based on that code? 1000 THNX

Hi, How would I use quotations inside a strng? Wouldn't it end the string? THNX

Hi I have a form with a list box allowing multiple selection. I want to be able to run a query and display values in a certain field according to the selection made in the box. Say, my box is fiscal years. If the user selects 1999, 2001, 2004 -- my query should only pick up fields in a table...

Hi I enherited an Access 2000 format db, that was used to run some simple queries on a dBase 5 table. So the process is basically to manually import the dBase table, rename it, and the queries pick it up. I tried importing a dBase table using Get External Data, Import -- but it gave me "invalid...

Hi, I have a form in Access, say myForm, that has a txt box in it, say myDate (cut off date for some client activity). I would like to bring the value of the txt box above (the value will change every time the user enters a new one) into my query. All I want is that value to appear on every line...

Hi, How would I change table field values into indicator columns? Say I have a table containing people and their pets: (If a person has more than one pet, his name will appear twice with a coresponding pet name) NAME PET Anna Cat Dan Cat Dan Fish Mike Dog Mike Cat Mike...

Hi, I was just wondering if it was possible to rename a table using a VBA module in Access? Say I have a table named myTable, and I want to rename it myTableOld. Thanks!

Hi How do I loop through Excel columns? IE how do I read all the values from row 1 say... Can I do For i: A to IV ?

Hi, I am doing some Excel cell comparison using VBA. It crashes when the value of cell is #VALUE! We probably won't have any #VALUE!'s but I want to treat this case just in case how do I say in VBA: If Range("A1") = #VALUE! Then ... do stuff