Search results

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?

I've used this technique successfully before. Just can't quite figure out what's wrong with this one. Here is one that works (populates my form): SELECT DISTINCT tblMaster.OperatingDay, tblMaster.[TO BA_REPORT], tblMaster.Hour_Ending, Sum(tblMaster.Import) AS SumOfImport...

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, Sum((IIf(IsNull([OffPeakHour]) And...

I could have to potentially create it hundreds of times a day. I will eventually have a few more users in the database and I don't want to have them coming to me everytime they want to enter data. I suppose I should have mentioned that sooner. Net is just a number that is NOT a plus or minus...

I do want to create a new table every time. Net is not a calculated field. These are all fields that would be hand keyed on the data entry form and populate the table. For more information. I will have a macro that will take the table once the data entry is complete and append it to a...

Thanks for your response. I am fully aware of and appreciate the concept of relational databases. I had worked on a mainframe version of one for well over 20 years. However I am not as familiar with Access and would appreciate the help there. I thought that's what this forum was about. Not...