Search results

I found my problem. There was some deleted data in a column outside the required columns. When I deleted those columns, it cured my problem.

Here is the SQL query after I enter the criteria: SELECT qryForm_Date.Date, tblInformation.strArea, tblInformation.strRegInd, tblInformation.strOrderType, tblInformation.strOrderNo, tblInformation.strFLOC, tblInformation.strDescription, Sum(tblProgram.lngProgramHrs) AS SumOflngProgramHrs...

Here is what it looks like when I save and exit Access. The only things are put in are under: strArea: [Forms]![frmStartup]![CA_Area] or [Forms]![frmStartup]![CA_Area] is null Date: Between Nz([Forms]![frmStartup]![CD_StartM],0) And Nz([Forms]![frmStartup]![CD_EndM],3000/12) strRegId...

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

plog, I was trying to do it in a table to make my life a little easier. I don't know much about Access. I have only taken 3 days of class, then I was thrown into the fire. Here is what I am trying to do: I created a query to populate 2 comboboxes on my startup form ( it has YYY/MM) as choices...

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 see how it has muddied everything up with the year and month being separate. I have taken you advise and used the yyyy/mm concatenation. It seems to be working. Thank you so much for you help. In your statement: Between Nz([Forms]![frmStartup]![CD_StartM], 0) And...

Paul, The two must be clashing. When I put in 4 (month) and 2014 (year) for the ending parameters. I get 1-4 of 2014 and nothing for 2013. I have a drop down box for start month, start year, end month and end year. I am beginning to think I may have to concatenate the month and year to get...

Thanks Pbaldy that worked like a charm. One more question if you don't mind, I have the same thing for years. I tried this: Between Nz([Forms]![frmStartup]![CD_StartY],0) And Nz([Forms]![frmStartup]![CD_EndY],2400) and it didn't work. Would you point me in the right direction?

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