So essentially I am trying to move a bunch of various excel and access files into one access database. Ill do my best to explain my predicament.
The monthly data (pounds processed) is inputted into an excel sheet by date, shift, material type, etc. There is a separate monthly summary sheet that totals the pounds produced for all material throughout the day by using a Concatenate function to combine the DATE with the SHIFT (Day or Night) and using a SumIf function to combine all entries totals that share the same DATE/SHIFT. Is there a way I can do a similar method in Access? Im able to concatenate easily enough on access, but I am unable to create SumIf style function that totals the pounds produced for all materials whose dates and shifts are equivalent?
Followup question, is there a way to have a date on a table and have each new record have the following days date?
Thank you!!!
Im relatively new with microsoft access, but Ive been using it for a couple weeks now. Ive had some coding experience, but its been awhile and on different programs.
-Nathan