Have a report query that identifies all program participants within a given month. Have a query that works well except that if the report is run after the beginning of new month, it includes enrollees in the new month, showing as negative numbers.
Since program participants often enroll prior to a given month or remain enrolled at the end of a given month, how do I structure the statement that would exclude those enrolling after a new month...
cambar
Last Activity: Dec 27 '10, 10:10 PM
Joined: Jul 19 '10
Location:
-
IIf statement question
-
This article, while informative, was not helpful. I already know how to structure basic queries with the types of parameters/criteria identified in the resource article. -
Trying to adjust Access query to enable obtaining monthly stats
I am a novice at SQL and am learning as I am going. Used below query to obtain the number of chargeable days visitors spent in various facilities during October. This query provides this information if no new visits for November have been entered in the database when the query is run. I need help with 'DateDiff('d',I If([ADATE]>#11/1/2010#...'
When run recently it included the new November visit days in the query result, showing these days... -
Thank you very much for your help. This works.
camgarLeave a comment:
-
NeoPa response does not count October days if there is no DDATE. If the visitor arrived in late October and has not yet departed, it will not provide the number of October days. And if the visitor arrived and left the same day, the day count is 0 when it needs to be 1.Leave a comment:
-
How to structure query to obtain the needed data
Database consists of records of visitors who have stayed at various contracted locations. Have ADATE and DDATE. Need to isolate all those who have stayed any days in October. So, in some cases they may have begun their stay in September and left during October or they may have begun their stay in October and not yet left. I further, need to be able to count the number of days each visitor has stayed during October.
I cannot seem... -
The database is not split at this point. Only have 3 users accessing the form on a regular basis and the number of records is fairly smallLeave a comment:
-
Multiple users of shared Access db cannot see new records entered by others
The database is on a shared network drive and one form primarily is used to enter new records. If user A enters records, user B cannot locate these records through the form unless user B first closes and then reopens the data entry form. What needs to be done to enable entered records to be seen by all users once entered, without having to close and reopen the data entry form?
Thanks
camgar -
Thanks very much. Worked great.Leave a comment:
-
How to program command button in Access Macro to require a password
I created a simple macro to open a form with several command buttons on the form. On one of these buttons I want to require a password for access. I am not a programmer. What do I need to do to make this happen?
Thanks for your help -
Already had tried the MMcCarthy approach. Perhaps I was unclear in my initial question. I need an expression that counts days like the DateDiff("d",[ADATE],DDATE])expression does except that for those stays where the person arrives and leaves on the same day, I need it to show 1 day - not 0 as the current expression results in. So, if I run a report based on the needed query, it will show all stays. It will count according to the original...Leave a comment:
-
Help with DateDiff query in Access.
Query set up as follows: DateDiff("d",[ADATE],[DDATE]) yields difference in days between arrival and departure. Want to adjust the expression so that if the ADATE and DDATE are the same, it will be counted as 1 rather than 0 days.
Any help would be appreciated. Thank you -
cambar replied to Access form/subform: On data entry, new record entry will not begin at first tab fielin Visual BasicThanks for your help. Hope to take VBA instruction soon to enable greater utility with Access. Thanks again.
cambarLeave a comment:
-
cambar started a topic Access form/subform: On data entry, new record entry will not begin at first tab fielin Visual BasicAccess form/subform: On data entry, new record entry will not begin at first tab fiel
When Access db is first opened and the first record is entered, tabbing on subform works properly. However, when subsequent records are entered, the subform retains memory of the last field filled in prior record and drops to this field once data is filled in main form. So, if I tab across the main form and expect the first field of the subform to follow, I am disappointed. Cannot figure out how to ensure that after saving a record the tabbing... -
Thanks so much for your response. Adjusted my query to obtain the responses I needed. Your response, in part, helped me correct what was missing in the expression I was using.Leave a comment:
-
cambar started a topic On Access Report: Need expr. that will count records where 2 chkbxs are "true"in AccessOn Access Report: Need expr. that will count records where 2 chkbxs are "true"
Have an Access report in which Column A and Column B are checkboxes. Already have totals for each column and percentages. Now need to write an expression that will count the instances in which both boxes are checked for a record. Cannot seem to get there. I am not a programmer. Any help would be appreciated. -
For proprietary reasons, cannot post copy of report. Let me try one more time to explain. The query I developed for the report in question has a date field. In this date field, the criteria requires the user to input the time period (dates) for which the report information is desired Example: Between[Enter Start Date:]And [Enter End Date:] When the report prints out, I would like to be able to total two of the columns which are checkboxes. Your response...Leave a comment:
-
Thank you for the option you provided. How do I then obtain the percentages using this approach?...Leave a comment:
-
Can't get a report total and % to work when dates are made variable in query
Created a report in Access where each record has two checkboxes "FIM Incomplete" and "FIMInaccurate" . Have been able to create totals and percentages at bottom of report for each. However, once I alter the query to require the user to enter a start date and end date for the period of time the information is desired, the expressions at the bottom of the report result in "error". What needs correction to allow for this...
No activity results to display
Leave a comment: