Summary: hi, I have a column containing dates (date datatype) now a user can select a date via php or whatever, the result the user has to get is the data stor...
Summary: Hi I need a query that will only show dates between the date in the date column and the date exactly a year before it. eg: 30/09/09 and 30/09/08 is ...
Summary: I print a daily report showing the production figures for each item. I now want to print, an accumulation of the production thus far. For example if I...
Summary: Overview: I have 3 queries searching 3 different tables for 2 fields. I then have one combining query that adds the results of the 2 fields from the ...
Summary: have to summarise something in ms-access. am using access 2003. i have a query with the following fields. (this query has some other fields also. this...
Summary: hello all, i am trying to find the the last friday of the present month. I am using the following which gives me the last day of each month: DateSeria...
Summary: The specific steps will differ depending on exactly what you want to show. You will need to set the desired criteria for the appropriate field in your...
Summary: I need SQl query to find out the last modfied date of columns in table. there are no date/time related columns in the table. But I what to find when ...
Summary: I am reporting daily performance data. I wish to compare weekday (M-F) data with Weekend (S,S) data. The actual date is called "TestDate". I create...
Summary: Hi, I have the following UNION query in MS Access: SELECT DISTINCT "DOM " & mDOMExceptions.ExceptionID as ExceptionID, mDOMExceptions.[Status], mDOMEx...
Summary: I have a report in my database is run off a cross-tab query. The report shows totals by quarter. In the crosstab query, Quarter is one of the column...
Summary: I have created an MS Access db, 2 of the fields relate to time...StartTime & EndTime. From this I have created a query to display the attendance time...
Summary: Where are the names stored? Do you want the user to enter the data into a field, or into a form based on a query? Life's more painless for the brain...
Summary: I'm currently working on a Access project, and I am in need of a certain validation rule. I am trying to find a rule which will only allow dates to be...
Summary: Hi, I'm designin sort of asset manager software and i'm already stuck with some SQL-querys... :) Tables don't have all the fields yet, because it's ju...
Summary: Hiya, I'm a novice please could anyone give me a simple step by step guide on how to build a CASE statement in MS Query? I greatly appreciate it. Kase...
Summary: I'm new to Access & need some help summing fields from different tables. I have 3 tables: Table Fields Products: Prod Name, Opening stock Supplie...
Summary: Hello! Maybe someone can help me... I want to write procedure containing some queries as SQL query. For example, I have queries "sglstr", "sqlstr1" an...
Summary: Could anyone tell me what this query would be like converted to Oracle? Thanks in advance. SELECT tblBlock.* FROM tblBlock INNER JOIN tlkpLocation ON ...
Summary: May I ask if any sql statement to compare date with today and give the result on each record? e.g table Date Name 8/1/2008 Tom 27/12/2008 Ann 2...
Summary: I try to include MS Access 2003 crosstab query design code (internally generated SQL) into a VB6 module. Here is the ColumnHeadings definition which ...
Summary: hi, i am getting below error,any one could help me please ------------ mySQL query error: SELECT m.id, m.name, m.mgroup, m.password, m.email, m.allow_...
Summary: I'm trying to design a query in Access that will find similar records (not dups). I have two tables with UserIDs. One is the result of a previous quer...
![[higher confidence]](http://static.computing.net/img/AT-red_x.gif)
- higher confidence, ![[lower confidence]](http://static.computing.net/img/AT-black_x.gif)
- lower confidence
