Search results

Hallelujah! It got all my data. I changed the properties in the table and the query on the CDate field to General Date. Then I changed the properties in the report to Short and SHAZAM! I did have to still put in the 02/01/2011 date instead of the last day of January. Puzzling and maybe there is...

I got the same error: "The espression is typed incorrectly or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplfying the expression by assigning part of the expression to variables."

Bob, Here is the error I just got after typing in the last expression The espression is typed incorrectly or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplfying the expression by assigning part of the expression to...

OMG, you are right, it is still there. Wow! Okay, let me try. Thank you!

Chris, using the right terminology has been difficult for me. I'm a pretty new user of Access and finding out that words like "Link" mean something different than it does in Excel, has been rough. What I meant on the reformat is I reformatted the cell in Excel to mm/dd/yyyy. Then imported the...

Bob, my excel spreadsheet that I'm importing all the data into the table from, does have the date/time version. So I reformatted it and loaded it in to the table. I got the same thing, no 01/31/2011 dates. jDraw, when you ask for my query, do you me to attach something here?

I have one field named CDate. The table that the query is running off of has 1900 records in it spanning November, December and January. I only want the month of January in my report. But the Between statement keeps truncating the last day of each month. I tried it on December and it did the...

In the criteria of a query I have the following listed on my Date column: Between [Start Date] and [End Date] The table I'm running off of has 1060 records in the month of January. But when I run the Query and put in 01/01/2011 then 01/31/2011, it truncates the last 60 records that are all...

I am using a Microsoft dbase template called Issues. I have eliminated all the forms, reports and modified it for my use. When I open it I get the following error. The form name 'IssueList' is misspelled or refers to a form that doesn't exist. If the invalid name is in a macro, an Action...

VNAInet; Thank you for responding. After reading my message, I realize that what I did. So, I have two tables. One is called "Issues" and the other is called "Tasks". The Task table has only the 10 tasks that the can be selected, plus a column that I put the abbreviations for these tasks in it...

I have lost way to much sleep over this one. Someone please help! Customers report their webpage problems through a on-line survey. The raw data is given to me in excel that I then import into a database I created. The customers picks from a list of 10 problem categories (Can't Find Form; Need...