Recent content by Geekette

dear fauzy, you could create 2 separate reports, the first would have groupheader page 1 detail0 detail1 detail3 detail4 detail4 detail6 groupfooter the second, the remaining...

thankx a bunch, gord! your solution is so much more simple than the one i thought of: i created a cross tab query with headings for each of the 30 day intervals. however, it is far too klugy. simplicity is always better!

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

thanx a bunch!!! i had *totally* forgotten the weekday function. i was getting all involved in the system vs. united states settings for dates - way off course!

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

going back to the days of typewriters, business letters written on 8.5&quot; x 11&quot; letterhead start approximately 1.5&quot; below the letterhead. left margin = 1&quot;, right 1.25&quot;. however, many companies have their own letter style, often because of the letter head design...

dear krazykt,<br>&nbsp;&nbsp;&nbsp;&nbsp;you have a choice of&nbsp;&nbsp;quick and inaccurate or slow and accurate :-)<br><br>&nbsp;&nbsp;&nbsp;&nbsp;using the latter route, export as ascii delimited, the information for your tables, then import the data into your new database. this actually...

Hi Benjamin,<br>&nbsp;&nbsp;&nbsp;&nbsp;There was a similar question back that I answered back on June 6th - check it out.<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;I've just written a FAQ &quot;Find and/or Replace&quot; which details the <b><i>Find & Replace</b></i> utility - go check it out

dear jekyll,<br>to select a random set of records try using the <b>top</b> function as in:<br><br><b>select top 5 <i>[fieldname1]...[fieldnamex]</i><br>from <i>[tablename]</i><br>where....</b><br><br>this will return a random set of records <u>unless</u> you add the<br><b>order by...

i think it's an &quot;improvement&quot; of a2k. in theory, (i believe a microsoftie told me this @ tech meeting) macro code that didn't &quot;convert&quot; to a2k's <font color=red><i>high vba standards </font></i>would be singled out. in other words, did this error happen on a vba script or...

dear mark,<br>i have had excellent results with a lovely utility named appropriately, <i><b>&quot;find and replace&quot;</i></b>.<br>the programmer, rick fisher, has versions for 2.0, 97 and 2000. you can purchase all three for under $50; separately they're about $20 each.<br><br>his website is...

dear metz,<br>what you need is the <b>min</b> function:<br><br><b>min([amount]) as (LowestBid) from <i>tablename</i> where.....</b><br><br><u> <i>then </u></i> do a sum:<br><b>sum([LowestBid])</b><br>

it would be simpler to use <b><font color=red>datepart</font></b> and the <b>now()</b> function:<br><i><b>datepart (&quot;mm&quot;, [now()] ) </b></i><br><br>or format your date field(s) mm (a single 'm' will not provide the leading zero)