Queries

Calculating Elapsed Time
How do I calculate elapsed time in a simple query when the starting time is before 00:00 and the end time after 00:00 ... all I'm getting at the moment is a negative number? ... 20 May 2010 09:28

delete files
Good morning and thks for your help, 1. Have on acces Qouestion with the following CODE 02304 02305 02306 Code is the item No 2. I have folder one my pc and i want to delete that foto (name of photo = code) -- Message posted via http://www.accessmonster.com ... 20 May 2010 10:34

count qry
using access 2003 i have the following qry SELECT DateSerial(Year([Date/Time*]),Month([Date/Time*]),Day([Date/Time*])) AS [Date], [AlarmData Table Filtered by Date].[Event Type], [AlarmData Table Filtered by Date].Parameter, [AlarmData Table Filtered by Date].Desc2, Count(*) AS MyCount, [AlarmData Table Filter... 20 May 2010 10:34

Week starts on Friday
Hi Groupies I have created a calculated field that is supposed to specify the week a job occurred. The week starts on Friday and goes through the following Thursday. My calculated field looks like this: WorkPeriod: Format(DateAdd("d",-1*(DatePart("w",[Ticket Date])+1),[Ticket Date]),"mmm dd""/""yy") & " - "... 19 May 2010 23:47

Access 2003: Select Next Item in Combobox
Hello, I have a combobox on a form and currently I manually select the next item for a member as needed. This is fine for 1 or 2 but typically I have to do this for 20+. Is there a way to select the next item on the list either using an update query or code? -- Regards, Chris ... 20 May 2010 22:41

Updating text field to new numeric field & moving minus sign to fr
Hi, I need some help with the below IF statement for update query. I got it to move the negative sign to the front of the number, but now it is removing all numbers after my decimal point. I've checked to make sure my formatting for [MyNumericField] is double and 2 decimal points. For example: [MyTex... 19 May 2010 18:17

Obtaining the correct results from a two table query
I have two tables say A and B, what I am trying to achieve with the query is just to display records that have the received field ticked in table A and the colour field in table B not containing �Y�. How do I modify the code below to achieve this? SELECT A_Date, A.Received, A.ID, B. Colour FROM A LEFT JOIN B... 24 May 2010 13:29

Mid string null value
I'm using the code below to display everthing after the pound sign (#) and it works for the most part, but displays the whole field for fields that don't have a pound sign. My goal is to display everything after the # if there is a #, otherwise leave the field blank. Mid([Description],InStr([Description],"#... 19 May 2010 17:10

in access, round up to nearest fraction(.5)
In MS-Access, How do I round a formula result up to the nearest fraction (Specifically the nearest half). Example: 1.3 rounds to 1.5, while 1.7 rounds up to 2 ... 19 May 2010 16:03

Access 2007 Append Query � Issue with automatically inserted b
Brad wrote: I can recreate the problem with these steps (takes about 2 minutes, if you want to experiment) Create new Access 2007 database Create Table1 with one field called �Customer Name� Add one record to this table Create Query1 with �Query Design� Pull the �Customer Name� field into Query1 ... 19 May 2010 13:48