Handing in my homework - Microsoft Access Expert 10


	Back to Access Expert 10 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Handing in my homework

Dan Jackson

3 years ago

Just trying to apply what I've learned. Does this look right?

I've manually typed this using my own cheat sheet. This assumes:

CustomerID is a number
City is a Text / String Value (Yes, realistically City will be a combo with an ID ref, but in this case, we're assuming string)
OrderDateStart and OrderDateEnd is a date value (Note i've converted the regional value to american)

Thanks

I tried to paste my code in here but noticed it removed all the double quotes and other stuff. what a pain. Will post screenshot instead (Yes, i enclosed in code brackets, not sure why it still removed them)

	Dan Jackson OP @Reply 3 years ago

	Dan Jackson OP @Reply 3 years ago

	Alex Hedley @Reply 3 years ago
Don't use smart quotes OrderT doesn't have an opening quote.

	Alex Hedley @Reply 3 years ago
Need to reopen the quotes on the first AND

Kevin Robertson @Reply

3 years ago

Your Ands need to be inside the quotes and some quotes are missing.
Remember you'll need Nz in case the value can't be fount to prevent an Invalid Use of Null error

Nz(DLookup("OrderID", "OrderT", "CustomerID=" & [Combo_CustomerID] & " And City=""" & [Combo_City] & """ And " & _

"OrderDateStart>=#" & Format([OrderStartDateField], "mm/dd/yyyy") & "# And " & _

"OrderDateEnd>=#" & Format([OrderEndDateField], "mm/dd/yyyy") & "#"),0)

	Dan Jackson OP @Reply 3 years ago
Awesome, thank you. Think I'll make a database which will translate English into this. Will help with the learning and assist in the future too. Thanks again R.e. Smart quotes. Yeah i know. Took it from Micro$oft Word for printing purposes. Will do something much better in a db

	Dan Jackson OP @Reply 3 years ago

	Dan Jackson OP @Reply 3 years ago
Ok, re-written broken down into sections! I'll print it and stare at it each day till it sinks in 🤣

	Alex Hedley @Reply 3 years ago
Something for the InteractiveLearningTool?

	Dan Jackson OP @Reply 3 years ago
Exactly what i was thinking

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

Next Unseen

New Feature: Comment Live View