Have an underlying query that uses a criteria date parameter meant to request begin and end dates on query use or when report is run. Unfortunately, when I run the report it asks me for the creteria [begin date] and [end date] twice. Any ideas as to why this might be happening? Any insights...
Have a projects pull down lookup field which is very long...36 possibilities you must go thru....when entering records often each new record uses the same projects pull down lookup field entry. Is there any way to have the entry form field default to the last record entry and only change with...
Have a field with a Company Key field...autonumber...and have a second field in table called company name...insert company name in report and for some reason the key number and not the company name prints in the report....doesn't happen in the queries or anywhere else...what's up?
Thanks for the start. Now just need totals on each category.
Report lists every category even if no record listed in group for the category. So thanks. Still need a total for each category...maybe after it lists each category. Any ideas to help there and the form will be great. Anyway...
Example
Report By Project Category Charges Summaries
Bill Cycle: 01/01/2004 to 01/31/2004
Project: Jenson Home Lot #23
Plumbing $ 0.00
Carpentry $100.00
Masonary $ 0.00
Electrical $ 75.50
Plumbing...
Really could use the help...thanks
Need report showing and summing every work category under every project....showing all work and expense categories even if no work done or expense paid under all the categories...must show "0"s where no work under a given category or expense under a given...
Fairly new at this compared to you guys...but here goes. Have database built which tracks hours and expenses. Tables are in place. Also even built Form for easier data entry. Problem is in creating a report I need to report for each separate project every category of hours types and expense...