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)...

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...

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...

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...

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 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...

May not be using the correct terminology here. I have a form that currently does not have a RecordSource. From this form, I want to create a table called "ICEA" with the following fields (which would be entered from the form): OperatingDay, Hour_Ending, Import, Export, and Net. Can this be...

How do you create a form that is not tied to one single record source? In other words, I want to be able to select the record source that it updates. I have a bunch of tables that have the same data structure but are separated due to geographical nature among other reasons. Is there a way to...

I have a macro that runs a query to find Max date of a table, then (I think) I want to use Dcount to see if that date exists on another table. If it does exist, I want the macro to stop processing and display an error message (i.e. "Error with file"). If it doesn't exist, let the macro...

I have a file that I want to import on a daily basis and append to an existing table in my database. The date changes each day. I want to create a query that checks to see if the date (of the first record) already exists before I import and append the new file. If it does, I want to show a...

I have a file that I want to import on a daily basis and append to an existing table in my database. The date changes each day. I want to create a query that checks to see if the date (of the first record) already exists before I import and append the new file. If it does, I want to show a...

I have searched high and low and I can't for the life of me figure out how to find the Minimum value of a column. This is my SQL: SELECT * FROM tblFinalMaster WHERE (((tblFinalMaster.OperatingDay)=[forms]![frmEnterParameters]![Combo13]) AND ((tblFinalMaster.[Checkout...

I have a form that I want to auto populate with some data based on a query. First off a form pull 4 pieces of data from a master table and passes them to a query which then auto populates another form that shows a lot more of the information from the master table in a more user friendly way...

What is wrong with this query? =IIf(IsNull([OffPeakDay],IIf(IsNull([OffPeakHour],Sum([Import]-[Export]),0))) What I want is to sum the field (Import minus Export which are numeric) on the form if the OffPeakDay AND OffPeakHour fields are null.

I have a report that I want to add some hand keyed data to. When I run the report, I want it to prompt me to "Enter Something". After I enter that information, I want that information to show in my report header. I feel like I've tried everything :banghead:.

Ok. So this should really be simple but for some reason, I am not getting the result I want. I have the following fields: Incomplete: Nz([Incomp],0) - my original field name was "Incomp". I renamed it to Incomplete and defaulted it to zero. Complete: Nz([com],0) - my original field name...

I have a field on a form that I would like to auto populate with the (concatenated) contents of 3 other fields on the same form. The first 2 fields are drop down boxes and the 3rd is a hand keyed text field. For example, the first field is Department (4 digit number from drop down box) Second...