Recent content by valkyry

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...

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.

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" &...

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!

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...

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...

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

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...

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...

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...

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...

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]=#" &...

Well, the query didn't change, just the function at this point. There is not a Group By in the query. here's the SQL view of the query: SELECT Trim([BillNumber]) AS Item, Trim([OptionCode]) AS FinishLevel, GetNumeric([RoutingNumber]) AS FinishingHours, IIf(Trim([BillDescription1]) Like...

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

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...