Recent content by macri

Update: I derped it and typed Actual Lbr/hs when writing thanks for the help all worked out great i'm doing the rest of my calculations this way despite how redundent it seems to be i guess this works just the same really though. thank you <3

ok ok i've got her set up like this, the calcutlations appear to be working however when i run it as i've set it up i get requested for first date second date shift and then for whatever reason actual lbs/hr pops up out of no where as a text entry point but it's not configured as a perameter /le...

bump? bump? bump? bump? bump? bump? bump? bump? bump? bump? bump? bump? bump? bump?

i have my query set up with calculated fields like so: PARAMETERS [First Date] DateTime, [Second Date] DateTime, [Shift] Text ( 255 ); SELECT Main.[Mth/day], Main.Shift, [Run Hrs]*[Actual Lbs/hr] AS [Gross Production - LBS], [Scrap Lbs 1]+[Scrap Lbs 2]+[Scrap Lbs 3] AS [Scrap Produced - LBS]...

also i just tried your method and it is now promting me after 1st date and 2nd date for RD/qa samples as an input /confused

i've also tried doing it as a calcutlated field in a query but it just blanks out Actual Net Weight: [Main].[RD / QA Samples]+[Main].[Total Scrap]+[Main].[Net Lbs]

hello and good day, I have a report set up using date range perameters i can grab a quarter of data or a month or a day or a whole year worth of data. on this report i also want to display in a text box the following... =([Main]![RD / QA Samples]+[Main]![Total Scrap]+[Main]![On Hold...

Hello and good day, I just thought I was finished with this one but sure enough someone found out i had extra time and figured they could milk one last thing out of this contract. Anyone still in school feel like people just want to take advantage of you!? I sure do... Anyways the report I'm...

LOLOL gina i could talk in soap based metaphores about software all day with you but i'm pretty sure i'd get banned from these forums, thanks for the humor and all the help. CHEERS

i probably wouldn't be so critical if i didn't have to pay for the soap, open source developed free soap cleans dirt better in my experience. i mean you have the worlds dirtiest people coming together to unite and make a soap that can clean everything and can be further customized depending on...

Gina, IT WORKED, Thanks so much for all of your help you've been wonderful if you have any insight for a young up and coming DBA/Web Dev/Server Admin I'd love to hear anything you would be willing to share! Also if you're this clever with sql and the likes what made you stay loyal to mr. gates...

i've been noobing around with this thing over the weekend here and there, i have everything else in my db finished out nicely all reports and what not this is really the last step and to be honest i'm milking it out until august 8th when my contract is up lol but i'm going to say i have a...

yeah it won't reformat dates properly they come out as just 401xx numbers for some reason and i still get the same errors. also i caught that error with the <>'s but it's still not working, could you show me an example of the between operator or link me to some decent documentation on it? the...

I was under the impression that ms access analyzes the first row of data (not titles) but the first row of data and changes the data type accordingly which i've tried doctoring with that microsoft work around on their support page where you make a fake row of data types for access to create the...

WHERE ((([Table1]![ID])>0 And ([Table1]![ID])>500));added this where clause i'm guessing something is broken with it because all the primary keys get turned into a 1 after it runs