Search results

That didn't work. Could someone look at the attached DB and show me how to get a grand total from the original report and two sub reports. Thanks Mike

I'll give it a try, thanks.

I have a report with two sub reports. What I want to do is sum the numbers from each column from each report to get a grand total. I have attached two pictures which will hopefully help someone understand what I'm trying to do.

This query, among other things, returns CASE_TYPE. One of the case types is being returned as “X” which is a valid case type. What I want to do either in this query on in a query based on TABLE 1 ,created here, is to change all CASE_TYPE “X” returned to CASE_TYPE “N”. Could someone please...

I have a form (case information) which has two sub-forms. I want to add a third sub-form. The form and the two sub-forms are linked by an audit id number The third sub-form also contains the audit id number. This form contains the worker names assigned to each case. (Sometimes one and other...

spikepl, That didn't make any difference, I'm still getting the same error. I'll take your sugestion and try rebuilding it. Thanks Mike

OK, I can fix that, do you think that is all it is? Thanks Mike

I have this query which I wrote sometime ago in SQL. I would like to convert it for use in Access 2010 and I'm having problems when I try and run it. I'm getting the error shown in the screen shot which is attached. Anyone have a suggestion? Thanks Mike Select...

I'm getting error when I run this query can someone help? Error is Missing ),] or item in query expression A.CD_STATUS_RECEIPT="H" AND A.DT_DISTRIBUTE Is Null AND A.DT_END_VALIDITY=#12/31/9999# AND A.AMT_TO_DISTRIBUTE BETWEEN 100 AND 500 AND Not Exists (Select 1 from NOLDBA_RECEIPT K...

Between the two red brackets should be DT_AND_TIME_SCHEDULED

I get this error message when I try to save the query before running it. "Syntax error (missing operator) in query expression. DateOnly: Month([NOLDBA_COURT_CV_107].[]) & "/" & Day([NOLDBA_COURT_CV_107].[DT_AND_TIME_SCHEDULED]) & "/" & Year([NOLDBA_COURT_CV_107.].[DT_AND_TIME_SCHEDULED]) "...

Access 2010 The production DB table has field called DT_AND_TIME_SCHEDULED and the data is stored as: 5/9/2007 1:30:00 PM I can’t change the format of the table field because it is our production DB. So if I’m looking to find any records that are scheduled anytime on 11/15/2011 what would I...

I just found something wrong with the query causing it to run and run. I corrected that and use Format(DateAdd("m",-1,Date()),"YYYYMM") And that did the trick. Thanks to both of you for your time and help. Mike

Yes that is what I do now, but I want the system to enter the previous month and current year for me. Sorry if I confussed you.

vbaInet When I enter your code "as is" in the criteria field for the date I'm still asked to enter the [YYYYMM] PLOG When I enter your code "as is" in the criteria field for the date the query just runs and runs. Either of you have any other suggestions?

Yes the would

I'm sorry the returned YYYYMM format would be 201110 for october

I have a query where a parameter value must be entered when the query is run. I run this query each month. The parameter value is [YYYYMM]. I would like to add something to the criteria which would enter the prior month when the query is run. An example would be the query is run in October...

That was all it was. Thanks for the help. Mike

When the user clicks on the SEARCH button on the main form a second form opens. The user then selects a column name from the drop down box and then enters what they want to find in that column. Example would be I search on the check number and and ask for check number 1245. Even though that...