Search results

InputParameters Hi All, Worked through the help and with the aid of Bob figured out some stuff, but in the help on how to create a form for entering criteria, item 10 mentions setting the InputParameters on the form, but within the properties of the form/subforms I cannot find where...

Thanks for the reply Bob, can you tell me how I go about your suggestion. Thanks

Hi all, Have a DB Report with multiple sub-reports requiring the user to input the same criteria for each of the subreports. eg. Enter Staff ID, Enter Start Date, Enter End Date Is there a way to enter the criteria parameters once and it be used for all sub-reports on the report instead of...

Sorry for being unclear, it is an error combining multiple queries. I have approx 10 tables pertaining to different areas of work, all linked by the StaffID table. I have a query on each table using a linked StaffID table and querying a specific ItemID count for a specific date range. I then...

Hi All, Question? How can I create subreports within a report? New to Access and need to results of several queries based on several tables on 1 report. All tables linked by StaffID and I want to show results from several areas on one report. Created queries for relevant tables but wish to...

Hi all, Resolved the date range issue, thanks, now I have a problem with the query results. I have a query based upon several other queries that have the StaffID and the linking factor. When I combine some of the queries it works fine, but with others, seemingly those that have no valves or...

Hi Rich, Sorry for my ignorance, but I am new to this. Can you explain how!

Can you elaborate Hi Rabbie, Can you please elaborate. To clarify, I have a number of tables with queries asking for staff id and date range and to calculate total numbers over that date range for the specific requirement. So in the report I have got it to ask for the staff ID once but it...

Hi all, Can anyone tell me if it is possible to input just one date range into a report that is accessing data from multiple table and multiple queries. I can create the report which gives me the info needed but I have to put the same date range in 3 or 4 time before the report is generated...