Search results

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

Hello all, I have an excel file linked in access and a table called main I've made a query to append the excel data (Table1) to the Main table as so: INSERT INTO Main ( [Mth/Day], [DS/NS], Shift, Line, [Product Code], [Product Description], [Mat'l], Pcs, Quantity, [Total Run], [Std lbs/hr]...

wow you weren't joking at all lol i literally did nothing but drag and dropped the fields from add existing fields. i may have just been over thinking this entire operation lol. sorry for the noobness lol i'll try and be less of a html guy from now on hahaha and here i thought web dev experience...

Ok i didn't realize that you could append a table when text boxes were bound to a field i thought this was only useful for searching/sorting data. when i originally learned access in 2000 i remember their being a cycle option of sorts so that when you tab out of your last input box it would...

Thanks for the tip, fairly new to access if you can't already tell. How exactly would you go about setting this up to add data? If it were up to me I'd set it up in MySql and just code an html form to update data unfortunately they like microsoft here. basically all they're doing is adding specs...

Hello and good morning/afternoon! I am currently in the process of redoing a production database that was originally setup in excel workbooks. What I'm currently developing is a form that interacts with my append query to add new entries which would be added to the current or "master" table...