Search results

I am trying to import from Excel and append to an existing table. My excel sheet is named tblStatus and I am trying to append it to my Access table "tblStatus". I get an error message that says "The first row contains some data that can't be used for valid Access Field Names. In these...

I am very new to the Access world. When I set up a query to be run, I am using a several combo boxes to to enter Criteria for the query. I have the following code, enter in the criteria "Between Nz([Forms]![frmStartup]![CD_StartM],0) And Nz([Forms]![frmStartup]![CD_EndM],3000/12)" It works...

I am trying to created a concatenated date of yyyy/mmm from a MM/DD/YYYY. After concatenating I get 2014/Feb, 2014/Jan.... which is the look I want, but when I sort it, April comes before Jan. Unless someone changed things and didn't tell me, I screwed something up. Any help would be greatly...

I am a newbie with only a few hours of training. I am trying to build a parameter query, where it will take a start month number from the Startup form. The start month (CD_StartM) is a ComboBox based on another query (qryForm_DateM). The end month (CD_EndM) is a ComboBox based on another query...

I am new to MS Access. I have had three days of class and then got thrown into a frying pan. We are wanting to use Access for the query and reporting portions. Found this site because I was looking and am completely stuck. I will be asking questions very soon. Thanks in advance for any...