Search results

That did the trick. Thanks for the help. Mike

I have a report that I run at the start of each month. The data is from the previous month so I would like to add something to the report to display the name of last month and the year. Can this be done and how? Thanks Mike

I believe I made the changes I thought you suggested. This time query didn't run and got syntax error (missing operator) in query expression 0","Date <= " & Format(Table1.Date,"\#mm-dd-yyyy\#") & " AND (Table1.TransID <= " & Table1.TransID & " OR Table1.Date <> " &...

Thanks, I'll give this a look today. I've been out due to a death in the family. Mike

I got what I believe to be the query

When I run this query I’m getting “#Error” in Balance field. What am I doing wrong? SELECT Table1.TransID, Table1.Date, Table1.[Check #], Table1.[Issued To], Table1.Description, Table1.[Case ID], Table1.[NCP/PF], Table1.Child, Table1.State, Table1.Payment, Table1.[Deposit Date]...

I have this query and it contains a Payment field and a Deposit field. Would someone show me what I need to do to generate a running Balance field for each row ? In some rows there will only be a payment value entered or only a deposit value entered and it is also possible to have both a...

Would someone please show me how to change this macro to ask the user to put in a start date and an end date before printing? Thanks Mike Sub Report1() ' ' Report1 Macro ' Macro recorded 7/17/2011 by Mike ' ' Columns("A:A").Select Selection.SpecialCells(xlCellTypeBlanks).Select...

Nope didn't work. Thanks for the suggestion

I'm running a query against a Oracle DB. There is a field in the DB which is called BATCH and the field content is displayed in a date format, MM/DD/YYYY. What I want to know is there a way, when running my query to convert the MM/DD/YYYY (example 1/24/2011) to MMDDYYYY (example 01242011) ...

I tried this and it ran but I got no results and I know I should have them. (When I just ran it in Query Reporter I got results) SELECT b.worker_id, iv_d_do_code, a.id_payor, b.case_id, a.dt_batch, a.cd_source_batch, a.no_batch, a.seq_receipt, cd_reason_status, sum(a.amt_to_distribute) AS...

When I try running this query I get "Data Type Mismatch in criteria expression" This is a query I had originaly written for a program called "Query Reporter" I'm trying to move it over to Access Any ideas? Select b.worker_id, iv_d_do_code, a.id_payor, b.case_id, a.dt_batch...

Thanks for the help

When writing a query is there some way to change a date format of mm/dd/yyyy to just mm/yyyy? Thanks

Looks like book links. I'll check them out tomorrow. Thanks again for the ideas! Mike

I was thinking that. So I'll take your advice. Thanks. Mike

I have a table which is populated from people entering data on a form. I have attached a sample of the table. What I want to know is there a way to add another field to the table, like balance and whenever someone enters a payment or deposit the balance field will show the running balance based...

Bettle, you did it! Thanks !! Mike

Sure, thanks for giving this a look. Mike

I tried it in the Form Header, Form Footer and in the Detail section