Recent content by Shawnus-Maximus

What I have: tblFlocks-(pk)FlockID, FlockName, BirdQty, DateLay, EggStd tblEggStd-(pk)EggStdId, EggStdName tblEggStdSub-(pk)(EggStdId, EggStdName, WeekOfLay),Std What I need (I think, am open to suggestions): I need to have for each FlockId the number of eggs produced during each of the 28...

If those excel fields are the result of formulas, then... I recently had the same problem. I copied the column in excel and pasted it as a Value. Then when I imported into access I did not have the #Num! problem. Changing the format in excel to text doesn't change the formula's result into...

The double query method worked. I then queried the two queries, and created a report on the new query:eek: . And calculated on the report. Thanks, SM

Sorry, I don't believe I was very clear. I need both this weeks and last weeks Feed Inv to use in the calculation. But, I can not use them summed together. Last weeks Feed Inv. will be added to this weeks Feed Del, and then this weeks Feed Inv. will be subtracted from that total. (Last...

Last monday's [Feed Inv]+ this weeks [Feed Del] - this weeks [Feed Inv]= Feed Consumed Table: Autonumber (is PK) Date Farm Barn Lbs Del (pounds delivered) Lbs Inv (pounds inventoried, this is a physical inventory done at farm) I can use Between[Start Date] And [End Date] in the criteria to...