by: Phantom_guitarist |
last post by:
I am trying to write a query (in PHP) which selects from a database all of
the items which are in the future. My query is as follows
SELECT * FROM news WHERE ((news.date)>$today ORDER BY date
...
|
by: Lapchien |
last post by:
done homework on Usenet and still stuck...
I have a parameter query that asks the user to input the 'slip reference'
based on the accounting period. This has now changed slightly so that the...
|
by: Deano |
last post by:
Ta for looking.
I am setting this SQL to the recordsource of a report but it's complaining
about a syntax error.
"SELECT tblemp.Surname, tblemp.Forename, tblAbsence.AbsenceDate,...
|
by: newnewbie |
last post by:
I have an Access database that I upload a data extract intoto daily. I want to create a query that will give me a list of dates that no data can be found for. E.g. there are no records created on the...
|
by: JD |
last post by:
Example
Give me all the dates between 02/02/07 and 05/02/07 ?
In Europe the answer must be 4 dates : 02/02/07 ; 03/02/07 ; 04/02/07 ;
05/02/07.
JD.
|
by: vkong85 |
last post by:
I am trying to write a query that will only display records between today's date and 30 days.
I've tried several different ways but nothing seems to work. Currently in the criteria of the date...
|
by: bobdydd |
last post by:
Hi Everybody
I am trying to be able to filter records by whether the date field
which is called "RiskDate" in the
recordset, is either:
1. Is Null
2. Not Null
The parameter in the query...
|
by: vjw |
last post by:
Hi, is there a way to query all days of a given month?
for ex: there should be 31 records for January..28 for february like that..
|
by: DAHMB |
last post by:
I have a report based on a query that has two dates that I need information filtered on, and then return the information in the same report. I have a date a case was opened and a date a case was...
|
by: khaing |
last post by:
How can I get the dates between two dates depending on days?
For example, if I give the start date '10-05-2010' and end date '24-05-2010' and days are Mon, Wed, Fri , the result should be...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: jfyes |
last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|