Queries

Querying for most recent value
I am rather much of a novice when it comes to developing Access databases, but have found myself in a situation at work where I have had to develop two recently. I have a situation where I am trying to query the database to determine placement types of all children in the database. A child may have had more t... 4 Jun 2010 21:24

AVG BETWEEN DAYS
Hello, Within my qry I would like to calculate the average daily production for the month. The data Im working with is: production volume, dates (which is a daily info.) and ID number. I'm working with tons of data that have production for each day of the year dating back 5 or more yrs. However I'd like to na... 5 Jun 2010 18:02

Looping through data with calculations
I have to loop through the data from one table (demand) and calculate total supply expected depending on the data from the other tables, here is example and expected result: Table A - (supply batches) Item Quantity a 10 b 8 c 12 d 20 Currently in stock C Item Quantity a 0 ... 7 Jun 2010 09:40

DatePart
I'm trying to convert "mm/dd/yyyy hh:nn:ss" date format to just time using DatePart function. I've used DatePart("hh:nn",[TimeIn]) and it returns "Error". I've used TEMP: DatePart("h",[TimeIn]) & ":" & DatePart("n",[TimeIn]) and it returns the time; however, I can't compare the result to other time since it ... 4 Jun 2010 17:00

Forcing an ambiguous outer join
I tried to add another table to my query with a Left join and I receive a message that my SQL contains ambiguous joins. It went on to say that I needed to create a separate query and I think it was telling me to combine the two. So I tried to do so but I received a syntax error about a missing operator. I se... 7 Jun 2010 13:02

JOIN Query very slow
Hello, I have the following Input tables Table1 Serial Item Date SerialandDate 123 Item1 01-04-2007 12339173 123 Item2 01-06-2010 12340330 234 Item1 01-10-2006 23438991 234 Item3 02-04-2010 23440270 234 Item2 01-01-2009 23439814 Table2 Serial Date Serial... 6 Jun 2010 17:09

create a form that collects parameters
Hi, i need a form where we search for a detail and the result should be published in the bottom, based on the result the user will decide what to do next in acess 2007. i refered the link below http://office.microsoft.com/en-us/access/HA100963141033.aspx#form_param in this some mistake is there in the macro... 4 Jun 2010 11:28

Total by certain time period
I have three fields in a table, and want to determine the total of the occurrences by a certain time period. The data I have looks like this. FGC RDate Occurrences 81 2009/01 1 81 2009/02 1 81 2009/03 1 81 2009/04 1 81 2009/05 5 81 2009/06 84 81 2009/07 1 81 2009/08 ... 4 Jun 2010 00:32

Switch Last Name First Name to First Name Last Name
Hello, Access 2003. I have a single field called "Name" in a table called "Members". There is about 300 records in a Last Name First Name format, example Doe John Moore Dave Johnson Jacob Mario (Some names have Middle Names or Sir's) How could I run a query to change the names to First Name Last Name? ... 4 Jun 2010 11:28

Maybe Update Query?
I'm floundering about and need someone to point me in the right direction. I have two tables: tblCostCat CostCatNm-PK-text TypeID-text GrpTypeID-text tblTransData ID-PK-number Employee-text CostCatNm-text TransDate-date Hours-number I need to populate the tblTransData with the TypeID in tblCostCat. ... 3 Jun 2010 19:03