473,320 Members | 2,164 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

when I enter this in my query date field Is Null >

I have a table with check numbers, date issued, date cleared, date voided. I would like a query that would show the check that cleared for the current month. When I enter this in my quirey date field Is Null >"#7/31/2015#" I get this message "you may have entered an operand without an operator". Can anyone help me?
Sep 23 '15 #1
5 1103
try to take out the " ", i believe that you do not need those for dates.
Sep 23 '15 #2
Seth Schrock
2,965 Expert 2GB
That is correct. Dates only have the pound sign (#). Strings use the double or single quotes (" or ').
Sep 23 '15 #3
Rabbit
12,516 Expert Mod 8TB
You entered Is Null >"#7/31/2015#" all on one line? That's not going to work. You need as least an OR or an AND in between them. In addition to what the others above said.
Sep 23 '15 #4
hvsummer
215 128KB
I don't think nothing (that is null) can > 7/21/2015 (not null)
lol. I suggest put only: > #7/21/2015# - on the first row of criteria.
then | is null | on the second row.
Sep 23 '15 #5
NeoPa
32,556 Expert Mod 16PB
Vera:
When I enter this in my quirey date field Is Null >"#7/31/2015#" I get this message "you may have entered an operand without an operator".
Is Null Or >#7/31/2015# will work. Alternatively, HVSummer's suggestion of Is Null on one line and >#7/31/2015# on the one below would also. Bear in mind this could cause problems if any of the other fields have multi-line criteria too. I would suggest the first solution and let Access handle the rest.
Sep 24 '15 #6

Sign in to post your reply or Sign up for a free account.

Similar topics

3
by: David Kuhn | last post by:
I have a query with a date field criteria of: Between And When the query is run, I am asked for the Start date and then the End Date. So far, so good. The records returned are all those in...
3
by: Bill Clark | last post by:
I have about 20,000 records pulled from Excel that I need to update. What I need to do is run an update query that bascially says: If a field is null, update it with the previous record value of...
2
by: buck | last post by:
I'm working on a helpdesk database - does anyone know how to auto enter the date in a new record; would it be soemthing like iif field is null auto enter?
2
by: hph | last post by:
Please be gentle; I am a relative newbie for php/MySQL, and most of what I am doing is based on being self-taught using someone else's well-written code, and my own googling the answers to my...
2
by: jacc14 | last post by:
Hi Hope there is someone out there that can help. I am sure this is an easy one although not easy to explain. I have a form which produces a report using a query. On the form I have a start and...
2
by: Supermansteel | last post by:
Our team does numerous tests each month. Each person can run a report to automatically tally up all the results for the quarter. I have then created a Form specifically to enter our Analysis for the...
7
by: nhkam | last post by:
I am using MS Access 2007 I have a transaction table which holds all records with posting date on each of them. I used a make table query to find out the max date hold in the transaction table and...
4
Daniel B
by: Daniel B | last post by:
I have a query that contains a "Service Date" field. I would like to form a Criteria statement to be able to enter any date (such as... 1/1/2011). I would then like to be able to run the query and...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
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...
1
isladogs
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...
0
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...
1
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)...
0
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...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
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
0
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.