Recent content by SpeedRacer

Yes, Group 1 is Farm, Group 2 Quarter

I have a formula if {Fish.Date} in Date (2016, 08, 01) to Date (2016, 10, 31) then "1st Quarter" else if {Fish.Date} in Date (2016, 11, 01) to Date (2017, 01, 31) then "2nd Quarter" else if {Fish.Date} in Date (2017, 02, 01) to Date (2017, 04, 30) then "3rd...

Thanks so much....Sorry for all the confusion i caused. your formula works great lbass.

This is what it looks like now: GH1 Pond# 114 wk# #/days fed tot lbs avg feed gf2 17 3 1655 552 gf2 18 6 3260 0 gf2 19 5 2505 0 gf2 20 4 2240 560 gf2 21 6...

Here it is: whileprintingrecords; numbervar maxave; if Sum ({Feed.Feed}, {@Week #})/{#Days Fed} > maxave then maxave := Sum ({Feed.Feed}, {@Week #})/{#Days Fed} Getting close, but still not right.

Sorry for the lack of info...i'm kinda new to this please be patient with me. i set a count on week number in the detail section resetting it on change of group. And placed it at GF2 level. i placed a total of feed fed per day at gf2 and then divided total feed by number of days. that gives...

The number of days fed is actually a count field being displayed at group 2 footer to give me the total number of days fed.

Group 1 is pond number group 2 is week number gf2 looks like this week # # of days fed #'s fed for the week average feed 17 3 605 202 18 4 800 200 and so on. I need the largest average of all weeks to...

Nope Doesn't Work....Thanks Anyway. :]

The other program uses Access 95. The database cannot be converted to 2000. If I could convert it I could copy the feature I am trying to replicate.

I am currently using a date entry form that someone else built. I cannot open it in design view. Anyway, before you begin data entry it pulls up a window asking for "Transaction Date". After keing in the transaction date you are then taken to the data entry form and the date field...