Recent content by Jester00130

  1. J

    Have a date field creteria parameter query that causes the parameters to be asked x2

    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...
  2. J

    Have a pull down lookup field which is long

    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...
  3. J

    Field of a table called last name...In report the key # prints and not the name...?

    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?
  4. J

    Need to summarize categories of table...even null values

    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...
  5. J

    Need to summarize categories of table...even null values

    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...
  6. J

    Need to summarize categories of table...even null values

    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...
  7. J

    Need to summarize categories of table...even null values

    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...
Back
Top Bottom