Search results

Hi, I am creating a report for a dot-matrix printer that will be printed on preprinted multi-layer forms - each page is 8.5" x 11". The report has a sub-report consisting of a randomly long list of items (5 columns) that is about 2" high roughly centered in the right half of the page. The left...

I am working on an application where the user selects a date from a calendar form and the matching records from a table are selected and listed in a continuous form along with a button to do something to the record. I have been able to make the calendar and the part that the user can click a day...

Is it possible to pre-populate (mark dates with color or box or similar) based on dates from a query? When the user clicks the date picker, I would like to highlight days that have data associated with them, similar to Today's Date is highlighted.

Hi, I have a query that summarizes data across 3 tables (Store, Sales and Payroll), Payroll and Sales are related by date; Store and Sales have store_id in common. My query groups records by a given date range and attempts to calculate the sum of the TotalSales from the Sales table and the sum...

I have built a report that shows 2 rows of sales data from each of a bunch of store locations. My table has the date, the location and the sales_amount. I grouped my query on locations. The resulting rows include a date and the sales_amount, and I have been able to get the sales_amount for a...