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 Rhinorhino 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: *

  • Users: valkyry
  • Order by date
  1. valkyry

    Cross-tab issue "absolute" to "relative" change??

    1st - let me say SORRY, i was being an idiot! I couldn't see what you were talking about and got hung-up with the "form" thing! NOW I see what you were telling me and it WORKS GREAT! THANK YOU THANK YOU THANK YOU VERY VERY VERY MUCH!!!! YOU ARE TOTALLY AWESOME! CAN'T THANK YOU ENOUGH! This...
  2. valkyry

    Cross-tab issue "absolute" to "relative" change??

    Let me just thank you for trying to help ... It looks like it's working. I got W1, W2, W3, W4, W5, W6, W7, W8 so it's looking good. I have to finalize.
  3. valkyry

    Cross-tab issue "absolute" to "relative" change??

    Ok, the part I'm having difficulties with is the fact that there is no form for the date ranges. The date ranges are preset. "create dynamic relative column headings based on an ending date entered into a form control. Your column heading expression would be something like: ColHead: "W" &...
  4. valkyry

    Cross-tab issue "absolute" to "relative" change??

    ok, will try that. is the form control needed? I have the startdate and an enddate of Between WeekStart()-57 And WeekStart()-2 as you saw. So I'm not getting what the form control is doing. anyway, i'll try it and let you know what happens. thank you!
  5. valkyry

    Cross-tab issue "absolute" to "relative" change??

    Well, the tables are extractions of the data set that is required for the report. One is to extract the dollar amounts and another is for the number of orders. Here's the Extract query for the Number of Orders: SELECT IIf([RepGroup] Is Null,Trim([AddressLine1]),[RepGroup]) AS Rep...
  6. valkyry

    Cross-tab issue "absolute" to "relative" change??

    Hello, I did a search and found a post that dhookum pointed to a Dynamic Crosstab ... FAQ703-5466 I was hoping I can get some help with that. I don't understand if you need the form for the date. I have a report that calls out a query which is based on two cross-tab queries. So the columns are...
  7. valkyry

    Increment on change?

    Here's the query result: PONumber ReceiptNo 1001967 100191 1002005 100191 Need it to be: PONumber ReceiptNo 1001967 100192 1002005 100193
  8. valkyry

    Increment on change?

    I have a query where it pulls the last ReceiptNumber from ReceiptHistory. I was hoping someone can help me on how I can have the last ReceiptNumber increase by 1 on change of the PO Number. Example: the last ReceiptNumber say is 12345 So in my query it says: ReceiptNo...
  9. valkyry

    Parsing data from a field?

    that was it. the funny thing is, if you saw the SQL View, I had Trim() in the query all ready and then the GetNumeric(). well, having the Trim in the function first seems to have fixed it! Thanks for seeing that. I'm sure I would not have figured that out! I would be spinning on my query and...
  10. valkyry

    Parsing data from a field?

    Hi CMP, This is what I am getting: see the "--", these are coming up Null. Item FinishDesc FinishingHours I4022 P1FF 0.50 0.50 I4022 FURN FINISH 11.50 -- I4022 FURN FINISH 17.50 -- I4022 FURN FINISH 24.50 -- I4023 SCAST 1.0 / FASS 1.0 1.0 I4023 SFIN 1.0 / FFIN 7.0 7.0 I4023...
  11. valkyry

    Parsing data from a field?

    lespaul, I need help, hence why I posted here. I'm not a programmer and not good with code (as you can see). I can get by with the REAL basic stuff, but beyond that I really don't know much. Again, reason why I posted. I certainly appreciate the help and yes, sometimes it's the code in it's...
  12. valkyry

    End-user to change default value?

    Hi TheAceMan1, This is what I ended up using on the form control. I created master tables for all the fields on the form that'll need to have a default value. nameofcontrol.DefaultValue = DLOOKUP("LaborRate","tblLaborRates","[EffectiveDate]=#" &...
  13. valkyry

    Parsing data from a field?

    ...Trim([BillNumber]) AS Item, Trim([OptionCode]) AS FinishLevel, GetNumeric([RoutingNumber]) AS FinishingHours, IIf(Trim([BillDescription1]) Like "*/*",Mid(Trim([BillDescription1]),9,9),Trim([BillDescription1])) AS ItemDesc, Trim([BM1_BillMaterialsHeader].[RoutingNumber]) AS FinishDesc...
  14. valkyry

    Parsing data from a field?

    thanks i got a compile error at the Right Wrong number of arguments or invalid property ...
  15. valkyry

    Parsing data from a field?

    thanks, not sure what's going on but I am only getting results with the FF and nothing else. Item FinishDesc FinishingHours I12005 P1FF 2.00 2.00 I12006-L SFIN .50 / FFIN 2.25 2.25 I12006-R SFIN 0.50 /FFIN 2.00 2.00 I13027 P1FF 2.00...
  16. valkyry

    Parsing data from a field?

    ...I12006-R P7STF 3.50 3.50 I12006-R SFIN 0.50 /FFIN 2.00 0.502.00 How can I add or change the code to say for the ones with */* to only use the numeric values after FFIN descriptions? Also, the numeric values from the descriptions that starts with a P#* to be added to...
  17. valkyry

    Parsing data from a field?

    ...They also have two options in the field. SFIN 5.0/FFIN 2.25 and of course inconsistently as well. SFIN 05.0 / FFIN 2.25 or SFIN 05 /FFIN 2.25. At least I found out that they just want the numeric value for the one that starts with FF*. So, how do I incorporate the above with the code provided?
  18. valkyry

    End-user to change default value?

    Anyway of having the field on the form (the control) have the DMax in the Default field? So, how would I write: =DMax("LaborRate","tblLaborRate") - this returns the highest laborrate regardless of date. need the return the laborrate of the most recent date (max date). but not the max on the...
  19. valkyry

    Parsing data from a field?

    ah, will try. thanks all!
  20. valkyry

    Parsing data from a field?

    Thanks CautionMP, it seems to be working!

Part and Inventory Search

Back
Top