Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. andrewhh82

    Cube Design for Survey Data

    ok, well regardless of the custom question issue. What if i wanted to cut by 2 standard demographics (say age and gender) if they are both in the dimDemographic dimension, I can't have the same dimension on 2-axis in a query. The reasoning for using SSAS is we have a lot of data that needs to...
  2. andrewhh82

    Cube Design for Survey Data

    Thanks for the reply, If I'm following you correctly, you would have a dimension for each custom demographic (such as business unit). But every time we upload data, we could have new custom demographic questions, so a new dimension would need to be built for each of those. This seems like it...
  3. andrewhh82

    Cube Design for Survey Data

    UPDATE: I've found this article that seems to be close to what I'm looking for, but it's not quite all there. I'm not really sure how to implement it. http://www.fcsm.gov/99papers/yost.pdf
  4. andrewhh82

    Cube Design for Survey Data

    Hi All, I'm struggling with the appropriate way to design my database/cube. I'll start with some background. I'm trying to develop a cube that will allow users to see results of survey data. This survey data consists of what we call demographic questions and metric questions. the demographic...
  5. andrewhh82

    SSIS - Flat file source changes slightly (breaks everything)

    Hi, I'm new to SSIS (using 2008). I put together what i thought was the correct way to import data from a tab delimited flat file, do some manipulation to it, and then insert it into SQL Server. Worked great. Then i had a slightly different flat file. It had all the same columns but a few...
  6. andrewhh82

    Interface with IE

    well, since i'm just learning i would start with IE, but i don't want to be limited to that in the future if i wanted to expand the app.
  7. andrewhh82

    Interface with IE

    Hmm. Yeah, i kind of wish i could record the URL every time i guess there was a site load event in IE.(if that exists) And eventually use it for other browsers. Going to that registry key limits me to IE and it doesn't capture all the sites one goes to, just the sites they typed in. (right?)...
  8. andrewhh82

    Interface with IE

    This may be a dumb question but i'm looking for some info that can at least get me pointed in the right direction. I'm a begginner to intermediate programmer and do it mostly as a hobby. I use Vb.net and C#.net. I would like to know how you go about creating an application that can interact with...
  9. andrewhh82

    requery listbox

    Hello. I have a weird problem. I have a listbox that is populated based on the selection made in a combo box. The row source of the listbox(lstCourses) is set to a query i've created. The code i've written is in the combobox's(cboName) AfterUpdate method. Private Sub cboName_AfterUpdate()...
  10. andrewhh82

    Requery Listbox

    PS. I'm running Access 2003. (2000 db format)
  11. andrewhh82

    Requery Listbox

    Hello. I have a weird problem. I have a listbox that is populated based on the selection made in a combo box. The row source of the listbox(lstCourses) is set to a query i've created. The code i've written is in the combobox's(cboName) AfterUpdate method. Private Sub cboName_AfterUpdate()...
  12. andrewhh82

    Help: Query one field with two criteria

    Perfect. I left out that i had a store field too, but i just did another inner join on that field as well, and it came back perfect. Thanks for everyone's help
  13. andrewhh82

    Help: Query one field with two criteria

    This unfortunately returns 1 row for each date. I would like to have the results as a row with 3 columns with fields basicly sku, price1, price2. Is this possible?
  14. andrewhh82

    Help: Query one field with two criteria

    Hi, and thanks. i have a table with 3 fields Sku #'s, a date, and a price for that sku. i also have a list of sku's i need to pull and 2 dates that i need to know the price for. Example: what is the price of sku# 10002 on 12/1/04 and 12/1/05. I need this returned all on the same row. I have...
  15. andrewhh82

    Report By fiscal dates

    Got it. I used the expressions in the query builder. Had to slightly alter it. used the following incase anyone else needs this. this is for a fiscal year starting on Feb 1. FYear: Year([fldDate])-IIf([fldDate]<DateSerial(Year([fldDate]),2,1),1,0) FMonth...
  16. andrewhh82

    Report By fiscal dates

    I'm not sure if that helps. Maybe i'm not using it right, but it seems like a way to just add the fields fiscalMonth and FiscalYear to a table. Maybe i'm just not imlementing right. I basically won't to click a report that shows the employees that attended classes in this or any fiscal month or...
  17. andrewhh82

    Report By fiscal dates

    I am building a Access 2000 database that tracks classes attended by people in my group. i have a table for attendance with the date they attended as field (mm/dd/yyyy). I need to print reports by Fiscal Month (ie. Fiscal Month 9 includes 10/1/05 - 10/31/05) My database currently is simple with...

Part and Inventory Search

Back
Top