Search results for query: *

Its working!!!! SDate = Format(ComboWeekendingDateStart.Column(1), "mm/dd/yyyy") 'Start Date EDate = Format(ComboWeekendingDateEnd.Column(1), "mm/dd/yyyy") 'End/Close Date Thanks for your help! Sometimes I just need a little bit of clue.

The fields are Date/Time fields. I think it is the combobox using the 0. There are 2 columns in the drop down lists. If I type my dates into my code it works just as it should.

Ahhh so something is going on with the date formatting. When I debug.print for Sdate and Edate I got: 12/31/1899 12/31/1899

So I have been working on it and my code now looks like the below. Code runs without errors but the Excel file is empty. No records. Private Sub CmdRunReport_Click() Dim dbs As DAO.Database Dim qdfTemp As DAO.QueryDef Dim strSQL As String Dim strQDF As String Set dbs = CurrentDb SDate =...

This is what I am trying to do: On an Access form: 1. User selects a start weekending date from a combobox 2. User Selects an end weekending date from a combobox. 3. User clicks a button to start the process. The process runs a query in Access with the dates the user selected and overwrites...

Thanks for the function. I can't seem to get the expression to work in a textfield on a report.

I am trying to Concatenate many records into a single text field on a report. I have 2 tables. tbl_Procedures PK - ProcedureID - Autonumber Procedure - Text tbl_ProcSedationFinal PK - MRN - Number Procedure - Number I would like for all the procedures to be listed...

Thanks. I will take a look at the example. There is only one comment and corrective action per question.

How do you recommend the table structure be set up? Something like.. Field Data Type Question Yes/No Comments Memo Corrective Action Memo And then add the questions into the table? There are also comments for each question and Corrective Actions. I...

This is the structure of the table, form and report... Table Question 1 Yes/NO Question 2 Yes/NO Form Did you do this? Checkbox Did you do that? Checkbox Report Question Yes Counts No Couts Did you do this? 1 3 Did you do that? 2 1 I need...

The other post is for a totally different database and a totally different report. My tables are normalized.

I am just using "Field" as an example. I didn't post my actual field names. I can't really post my actual field names and sample data. The example I posted is exatly what the report looks like. Fields are listed down the left side with yes and no counts. The fields are listed down the left...

That is true. I was using ABS before because I kept getting a negative number but that was because I had the wrong formula. So now my expression is: =Sum(IIf([Critical_Lab_Value_Report_Completed] And [Total_Minutes]<=60,1,0)) It works wonderfully.

=Abs(Sum(IIf([Critical_Lab_Value_Report_Completed] AND [Total_Minutes]<=60,1,0))) It worked! Thank you!

I thought my Access skills were better than this. Glad this site exists to get me unstuck. Sometimes my brain pauses. I have a report that lists several different fields and the counts of yesses and nos. It looks like this. Field Yes Count No Count Field 1 2 3 Field 2...

Ok so I decided instead of using time and hours, because that wasn't working well, I would use minutes. So now I am trying =Abs(Sum(IIf([Critical_Lab_Value_Report_Completed],1,[Total_Minutes]<=60))) It dosen't appear that the AND part is working. I need Critical_Lab_Value_Report_Completed...

I have an Access Report and I am trying to display a total if the Count or Sum (Have not gotten either to work) of Lav Values completed = yes (1) AND Total Hours are less than are greater than "01:00" I have written an expression...

Sweet! That worked! Thank you.

Not sure what you mean. When I am in the Format Axis window the category is set as a Date.

How do I change the X axis on a chart to only show the months for the date range entered? The data is displaying the correct data points but my x axis is showing all the months and years ever entered into the database