Recent content by WLC

I need some assistance. Let me preface this with I do not know VBA at all so pointing me to the right command in macro builder would be greatly appreciated. Here's what I have: A macro that deletes a temp table (DeleteObject), imports a file from a network drive (ImportExportSpreadsheet)...

That worked. Thank you. And thank you for the advice on posting threads.

I'm having problems with an Update query. I have data coming in on one file that I am loading to a temp table that I want to update on another table in my database. The problem is that when I run my update query, it is wiping out everything that DOESN'T match. I have 5 fields that MUST be...

plog hasn't posted anything since Feb 3rd. I posted a reponse on the other thread. Thanks for your help!

Original Post: I have the following query: SELECT DISTINCT tblMaster.OperatingDay, tblMaster.[TO BA_REPORT], tblMaster.[From BA_REPORT], tblMaster.Hour_Ending, Sum(tblMaster.Import) AS SumOfImport, Sum(tblMaster.Export) AS SumOfExport, Sum(([Export]-[Import])) AS Net...

This worked perfectly. Thank you. Could you possibly help me with another thread? http://www.access-programmers.co.uk/forums/showthread.php?p=1328767#post1328767

***REVISED*** I would like to [Enter Date] 01/12/2014 (January 12th, 2014) and get 01/01/2014 through 01/31/2014 (January 1st, 2014-January 31st, 2014)

I would like to [Enter Date] 01/12/2014 (January 12th, 2014) and get 01/12/2014 through 01/31/2014 (January 1st, 2014-January 31st, 2014)

I posted this yesterday and didn't seem to get quite the answer I was looking for so I'm reposting. My original post: How do you calculate or find Month To Date in a query as it relates to a hand keyed criteria. For example I have a field called Operating Day and right now my criteria in my...

The report is based on one day so the user would enter 1/12/2014 (January 12th, 2014) from this query (attached image EnterDate.jpg). Then there is a subreport from the main report that runs this query (attached image MTD.jpg). And you are correct in your assumption that I have no data past...

I do have a query that obtains the date for the report (it's the record source for the report). I have it set up where there's a parameter that I have to enter the date and that's what populates the report. I'm just not sure how to tie the two together (the date that I enter in my parameter...

How do you calculate or find Month To Date in a query as it relates to a hand keyed criteria. For example I have a field called Operating Day and right now my criteria in my query is Between DateSerial(Year(Date()),Month(Date()),1) And Date(). Works perfectly. I'm using this data in a sub...

Sum(IIf((Note >= 1 And Note <= 6) OR Note = 23 OR Note = 24, PlateNumber, 0)) worked for me Thanks for the quick responses.

tested and worked. add 2 more numbers in there: If Note = 1,2,3,4,5, 6,23, or 24, I want to sum a field called PlateNumbers. I tried: Sum(IIf((Note >=1 And Note <=6) and (Note >=23 and Note<=24), PlateNumber, 0)) but that didn't work (I think this is a case of I can't see the forest...

I have a field I need to create on my report that needs to be based on what is in another field on my report. If Note (that's my field name) = 1,2,3,4,5, or 6, I want to sum a field called PlateNumbers. Can anyone help me with the syntax?