by: deko |
last post by:
This runs, but does not narrow to current week.
suggestions appreciated!
SELECT lngEid, dtmApptDate, Subject, Appt_ID
FROM qry002
WHERE (dtmApptDate BETWEEN
DateAdd("d",-weekday()+2,) And...
|
by: news.online.no |
last post by:
In a query, I need too be able to show if a parent record has a child
record.
Using the query in a combo box too select record in a form.
Thanks
:)
|
by: John |
last post by:
I have a query that returns this recordset:
Bob, 1/1/2000
Bob, 3/1/2001
Bob, 2/4/2004
Bob, 5/9/2002
I need the query to return this instead:
Bob, 2/4/2004
So, it needs to return the most...
|
by: perryche |
last post by:
Experts,
I have the following scenario:
Table1: RecordID RecordDate ...
I want in a query to show me within this RecordID, only the latest
RecordDate and info. I know I can use the Max...
|
by: Smriti Dev |
last post by:
Hi There,
I'm creating a form based on query and I want the appointments to be ordered
from top to bottom with the top appointments being closest to the currrent
date.
How can i set this up in...
|
by: markryde |
last post by:
Hello,
I am trying to add the current date to a file name in python script
like thus:
import os
import sys
import rpm
import time
import datetime
|
by: jmarr02s |
last post by:
I created a subform with 4 separate fields (textboxes) each containing
an 8 digit date
I want the most current date to show in each of the four fields
So under properties for the subform...
|
by: mcca0081 |
last post by:
hi - i'm trying to delete one of the duplicate records based on the
most current date.
here's the code for my access 2000 db. any help would be
appreciated!!! - thank you kindly
Sub...
|
by: susinthaa |
last post by:
Hi,
Is anybody knows that how to display the current date in perl?
As I am new to perl, I find some difficulties.
please help me.
Thanks & Regards,
susi
|
by: GraemeC |
last post by:
I have a form (single record form) that loads records from a query that are sorted date order as the records are viewed in date order. Some dates are in the past and some are in the future. Currently...
|
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: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
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: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|