Search results

So how am I to group and sum? thats where I am at loss..

How would I go about creating a query that would summarize how many items i received per month? I have a date column that tells me the date an item was received..

I would like to query my table and display results by quarters. # of items received for the 1st, 2nd, 3rd, and 4th quarters of the year.. I do not know how to do this unfortunately.. :(

(Excel) In column A i have numbers, that look like this: 123456-1234 I'm trying to formulate something simple that would add a 0 behind the the 8th and 10th number, so the numbers would the look like this: 123456-120340.. And i would like to every row in the column. I'm not a "coder" by no...

**Smacks self in forehead** thanks folks!

I have a table that I enter in the ID's of records that I want to do various updates on.. The database is a work tracking database, so as different tasks get complete, dates are entered into fields to reflect the work being complete. I am trying to simplify typing dates by building an update...

Thanks Bob!

I would like to select items that are 45 days old.. I could count the days and use the ">=" but is there a simpler way?

i figured it out.. smh.. long day.. it was returning the right data.. just forgot to throw count back in there... Thanks for all your help..

its returning every record.. im so confused..

But its not giving me the right information! arrrgh!

Thanks Bob! New query worked instantly..

dont have enough posts.. yet lol

Unfortunately access keeps adding those quotes and i have no idea why!!!!!!

Still a no go... i attached a pic of what i have..

having an issue which is making me feel very incompetent.. My table has a creation date field (field type set to date/time).. I'm building a query that will show a count of how many records where created before a certain date. So in my query of course i put the CreationDate field and its set to...

Thanks Guys!

I have a report that displays the number of unfinished items that need to be completed. On this report i want to display the date of the oldest unfinished item. There is a 'Date_Created' field in my query and thats the field that the information would come from. Thanks in advance.