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!

Register Log in
  • Congratulations derfloh 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. pete1505

    Importing Portions of an Excel File (Complicated!)

    Not too familiar with Ranges, could you expound a little?
  2. pete1505

    Importing Portions of an Excel File (Complicated!)

    I need help creating a procedure that will first create, and then update on a regular basis, a table in Access via information in an Excel file. I already know how to link Access to Excel info, but this is going to be a bit more specific. Description of Excel File: I have a file with four...
  3. pete1505

    Multi-Field Propagation using List or Combo boxes in a Table

    jjlogan, Ahhhh.....normalization. I got so caught up in how my table would look to the users that I forgot that I don't even need that information in this new table. I'll create a view or report later that shows the name with the number. But you are absolutely correct that this would...
  4. pete1505

    Multi-Field Propagation using List or Combo boxes in a Table

    I have a table containing several foreign keys from other linked tables. In particular I have a list of countries and their corresponding number that has been assigned to them. I want to set a the "number" field to be a picklist in the datasheet view where the user can click the dropbox arrow...
  5. pete1505

    Query Criteria Based on Form Data

    Okay, I'm sure you're getting tired of me now! This works great now and the report is working for all dates.....HOWEVER.....I need to get the report to show zero "0" in the column if nothing was completed. Any way to do this if no information is actually being passed through for that facility...
  6. pete1505

    Query Criteria Based on Form Data

    Currently the last part of the crosstab query code looks like this: PIVOT [F - Completed Facilities Summary].FT_Name; How would I tell it to list out the actual FT_Names as column headings and keep them there even if no data is coming through for those facility types from the other queries...
  7. pete1505

    Query Criteria Based on Form Data

    Ginger, How do I force it to show those? Right now the Crosstab query is trying to pick and group all "FT_Name" Facility types as the column headings. How do I specifically tell it to use certain names and put the correct data in those columns?
  8. pete1505

    Query Criteria Based on Form Data

    PHV, You were kind of correct. Actually the number is decreasing in this case and the report is wanting to show numbers in a column for which no data exists in the crosstab query during certain time-frames. I need to get my crosstab query to show a zero "0" for these facility types instead...
  9. pete1505

    Query Criteria Based on Form Data

    Okay, I figured out why it doesn't work past that date. I was not doing what you were asking. I took out all the parameters and entered a date range of 7/19/2004 - 1/24/2005 directly in the FacNum(5) query. The report wouldn't run. When I went into the report design it was not able to find...
  10. pete1505

    Query Criteria Based on Form Data

    S - All Facilities Query": SELECT TASK_ORDER.L_Name, COUNTRY.WBS, FACILITY.C_Name, FACILITY.F_Name, Count(DELIVERABLE.[Del_#]) AS [CountOfDel_#], DELIVERABLE_TYPE.Del_Code, Sum(FACILITY_DELIVERABLE.FD_Amount) AS SumOfFD_Amount, FACILITY.FT_Name, FACILITY.Number FROM (DELIVERABLE_TYPE INNER JOIN...
  11. pete1505

    Query Criteria Based on Form Data

    S - Completed Facilities Query" is actually the query that FacNum(5) is based on. Forgot to mention that. That query just gives me a list of facilities that have been comleted out of my overall list of all facilities in varying states of completion. FacNum(5) was then created to try to filter...
  12. pete1505

    Query Criteria Based on Form Data

    If I run the queries alone using typed in dates (not referencing the form controls), they work fine. So Yes, and Yes. Here are my queries: Query 1: "FacNum5" PARAMETERS [Forms]![Filter Form - Completed Facilites]![R1] DateTime, [Forms]![Filter Form - Completed Facilites]![R2] DateTime...
  13. pete1505

    Query Criteria Based on Form Data

    Actually, I'll clarify a little. It's 7/18/2004 which is the last date that the process will allow to work. Any date after that and I get the error! It's wierd!
  14. pete1505

    Query Criteria Based on Form Data

    Actually, GingerR, for some reason this works for all dates up to 8/1/2004. All prior dates the report works just fine, but for any date after this I get an error that says "The Microsoft Jet Databae engine does not recognize " as a valid field name or expression". And then the thing blows up...
  15. pete1505

    Query Criteria Based on Form Data

    Awsome! Works fine now. Thanks for your help.
  16. pete1505

    Query Criteria Based on Form Data

    Here's an interesting one. I have a crosstab query that uses a query, that uses another query which has a date field with a criteria that states the date must be between the dates the user enters in two text boxes in a form. Problem is, the report I run is based off the original crosstab query...
  17. pete1505

    Part of IIF Statement in Access Query Not Working

    Will do, sorry if I wasted your time, but thanks for your consideration!
  18. pete1505

    Part of IIF Statement in Access Query Not Working

    I didn't mean to, and I won't in the future. I'm new (as of this morning) and I didn't know the proper forum to post this question. After I posted in the first forum I found this one which looked more promising for my question. Thanks for the tip though.
  19. pete1505

    Part of IIF Statement in Access Query Not Working

    Nevermind, I re-read your post and figured out what you meant. I needed to add the following before the final ')' ",DELIVERABLE.HQ_App_Date)". Now it works just fine. Thanks for stearing me in the right direction!
  20. pete1505

    Part of IIF Statement in Access Query Not Working

    That's what I figured, but I needed another set of eyes to look at it. A co-worker wrote the code, and I've been modifying it. Problem is, we both though that the last IIF statement would create the value (become the "else") if the first IIF statement conditions were false. Thanks for your...

Part and Inventory Search

Back
Top