Search results for query: *

Hello: I have a text box on a form who's control source is the primary key field of a table. I would like the form to open to the next value (to add a new record). The following expression sets the default value for the Data of this text box. (DMax('[DTNumber]','[Sypher Drawing Transmittal...

We have a report where we, among other things, add the total number of particular values of field over a monthly time period. We have documents that are given a status value (SDComment); "approved", "rejected", "Resubmit" etc. and we then total each category(status)for that month in the report...

Hello: I have a monthly report based on a query , grouped by submittal number, that sorts documents by the date they were responded to. The criteria of the SDSRDate (Response date) is set to filter only the previous months responses. The report is grouped by SD number (submitted transmittal...

I have a report based on a query that sets the date range for monthly reports. Can I use the calender control to set the dates in the criteria "Between [Enter Start Date of Month:] And [Enter End of Month Date:]" in the query instead of typing in the actual dates in the pop-forms? Thanks for...

Hello Everyone: I've re-read most threads similar to my problem but I'm still having trouble counting the total number of sorted groups generated in a report . Here's what I have. A report based on a query that sorts month,by week date and sorts/groups by a document transmittal number...

Hello Everyone: I would like to increment the numeric value of a particular control on a form by one then move the focus to another control when I open this form for data input only. The related table is indexed and the number to be automatically increased is a primary key. This would set...

Hello: I have reviewed a number of threads and help files dealing with counting including... 703-669669 Expression showing count 958-658402 counting specific values using Sum (IIF(.. 707-668215 similar using Dcount( Help File.. Calculating a total or other aggregate values I cannot...

Hello Everyone... Is it possibe to change number values that have been entered in a number field originally formatted as standard/single/1 decimal, such as 40.1 to be automatically converted to read 40.01? Unfortunately, now we need to have 40.09, 40.10, 40.11 to 40.99 Thanks for your time and...

I posted last week (07/04/03)regarding setting the monthly date criteria in a query to apply to different tables and monthly reports.Thanks to both Rick Spr and scriverb for your help and support. As RickSpr kindly outlined, I can use VBA to build a SQL query string to plug in a choice of...

We are dealing with documents. I've tried all the suggestions in the archive but can't seem to set the criteria of our date field in a query to limit the dates to the current month. We would like to use the query to generate monthly reports of engineering document status. I've tried Threads...