Between Date and Date 7 - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Between Date and Date 7

Tim Slade

4 years ago

I am in process of trying create a Db to keep track of household bills including due date and amount due. I want to select bills due in the next 7 days. even though the sample data includes due dates within that time period the query brings back a query result that is blank. No company name, no due dates and no amount due. Nothing

Also, I have set a relationship between two tables. First, I used the PayeeID in both tables and when that didn't work, I tried relationship between NameCompany in both tables (as the screen copy shows).

Also, the BillsT shows only the PayeeID from the Payee table rather than the Payee NameCompany.

I have deleted the file and started over several times and get the same result.

	Adam Schwanz @Reply 4 years ago
Can we see some images of the query? Snip & Sketch

	Tim Slade OP @Reply 4 years ago
I tried to post a screen image, but it warned that the file size was too large.

	Adam Schwanz @Reply 4 years ago
Did you use the same method from the video? Unless the website is having some trouble it should work.

	Scott Axton @Reply 4 years ago
You would just have to optomize it for the web and reduce the quality a bit. The resolution od the screen capture is what I'm speaking about. What image program are you using?

	Tim Slade OP @Reply 4 years ago
Print Screen on the keyboard.

	Tim Slade OP @Reply 4 years ago
What I tried in the Criteria for Due Date was: Between Date() and Date() +7 The resulting Query shows no records at all even though I have dates within the range.

	Adam Schwanz @Reply 4 years ago
I'd need an image to be sure, it could be multiple things. You could have a join issue, incorrect syntax or field. Did you try print screen on keyboard and paste it into paint then crop it down to only the relevant query?

	Tim Slade OP @Reply 4 years ago

	Scott Axton @Reply 4 years ago
Please give the image another try. Orient it horizontal and crop it so we can read it. Way to small. Don't just do a print screen. See Screenshot and Snip & Sketch

	Adam Schwanz @Reply 4 years ago
Also if you can show the field names/criteria in the query that's a big piece.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View