Search results for query: *

I'm creating an aging receivables report, using the invoice date as a header. I would like headers like &quot;+121 Days&quot; for ([inv_date]<Date()-121; &quot;91 - 120 Days&quot; for ([inv_date] Between Date()-91 And Date()-120 , etc. Basically, every 30 day interval starts a new group. How do...

I am designing a report which will count the number of sales a salesperson makes over a period of time. The report currently breaks with headers and footers on salesdate and salesperson, with total fields in the footers. example: =&quot;Total for Salesperson &quot; & [saleslname] & &quot...

I am designing a report that will break on a date field [posted], with grouping on the Week level. I would like the header for that date to show the first day of whatever week the date fields are in. For example if [posted] has values of 9/11/00, 9/13/00, and 9/19/00, I want the [posted]...

I need a reliable way to generate an invoice#. Autonumbering is not the answer, as an invoice can have more than one item, and I want each assoicated item to have the same invoice#.<br> My current solution is pretty klugy [and ineffective!]: I have a separate Invoice# table which (when a button...

I want to be able to enter, for example &quot;17&quot;, in a date field and have that converted to the current month and year (e.g. 17 Dec 1999). Any suggestions?

In the database there are several companies. Currently there are 2 sets of rates (there may be more later on).<br> How should I design this relation? I currently have a Company table [which includes a Long Integer field for RateTable#]; a RateTable table [companyID#, RateTable# as a Counter...

The user must first choose a doctor, then choose an appropriate office location.<br> The Parent combo box contains the list of doctors, with did# as the indexed field.<br> I want the Child combo box to contain the offices for the chosen doctor. The office has an index of did#,did_loc#. How can I...