Search results

Hi How is it possible to change row in query column title? I have query which look like this: [number] [start time] [end time] 1224345 12.6.2007 13.6.2007 I want that my query should look like this: [number] [start [end time] time] 1224345 12.6.2007 13.6.2007

Hi. I'am trying to count: todays date -12 month. So how I tell access that I want answer which date is year from this date? Or how I must "write" 12 months in SQL?

Hi. I'am trying to make script which counts time durations together from table. My table looks like this: [start time] [end time] [duration(min)] 12:20........13:10.......50 13:20........13:40.......20 And my query should look like this: [hour] [duration] [fault happened]...

Hi. How I can delete all rows from my table whit on query? Also I want that when I delete rows from my table index and other settings will stay in table.

Hi. (I already ask how to delete rows but it looks too hard to make so I invent new idea) How I can add lines (INSERT INTO) into table so that Access does not add lines which already are in the table??

Hi I have to make a query which deletes duplicate rows from my table. How I should start to make it? Can I do it whit one query or does this operation needs more queries? I know that DISTINCT works but how I can set it to DELETE operation? I have try to use command DELETE DUPLICATES FROM Table...

Hi This shouldn't be hard SQL-statement but I just doesen't got it how it should be done. I have a two queries which lists same things. One of my query1 look like this: [start time] [end time] [duration time][fault] xxx.............xxx...........xxx................xxx Now I Count different...

Hi I have query1 which shows different channels and those fault duration. Like this: [channel] [fault duration] cnn............5 bbc............2 and so on How I can make a query2 which checks from my channel table are there every channel. And if it not then adds it and set it [fault duration]...

Hi I have make a combo box which uses table like this: [month] [start date] [end date] january 1.1.2006 31.1.2006 february 1.2.2006 28.2.2006 ... When user chooses month I want that start date will be showed in textbox in form. And end date will be also showed in another text box. So I...

Hi I have a table where is listed all happened faults from a month period. Every fault have start time and end time field and ip field which tells what device has been "broken". Now I'am trying to calculate how many faults has happened in every day. I have make a query from the table which looks...

Hi I have a form which has two command buttons A and B. I set that when somebody click the button A then table A will be open and so on. But I dont want that table opens in new window. I want that I can "draw" a "box" in form where the table will showed. So can anybody help me and tell how to...

Hi I' am trying to make a form which executes a macro in every minute. I have put the Timer Interval to 60000ms. But now the form executes the macro only once and I want that macro will be executed always after one minute. So how I can make this work? Do I have to make somekind of loop in code...

Hi I have maded a simple macro which completes query which makes a new table. After that the macro saves the changes and closes the Access. Everythig works fine when I complete the macro from the desktop icon. But when I try to complete the macro from Windows scheduled task (in every three...

Hi I want reduce one minute from my date field. My date field looks like this: 17.3.2006 3:57:00 and I want it to look like this:17.3.2006 3:55:00. I have tried to make it like this: DATEADD( minutes, -2, [StartTime]) AS NewStart. StartTime is date field. But this doesent work. Could somebody...