Access report

%3CLINGO-SUB%20id%3D%22lingo-sub-2041467%22%20slang%3D%22en-US%22%3EAccess%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2041467%22%20slang%3D%22en-US%22%3E%3CP%3EHI%2C%20I%20am%20very%20new%20to%20using%20access%20and%20i%20have%20created%20a%20report%20to%20show%20due%20today%20task%2C%20i%20need%20to%20have%20the%20same%20report%20but%20to%20show%20due%20tomorrow%20tasks.%20Can%20someone%20please%20tell%20me%20how%20to%20do%20this%3F%3F%3F%20Is%20it%20as%20simple%20as%20changing%20the%20expression%20from%20this%20....%20%3Ddate()%20to%20something%20else%3F%3F%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2041467%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2041736%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20report%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2041736%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F459380%22%20target%3D%22_blank%22%3E%40Daniel_Pineault%3C%2FA%3E%26nbsp%3B%3CSPAN%3Ethanks!%20it%20is%20now%20showing%20tomorrows%20but%20also%20still%20todays.%20what%20if%20i%20just%20want%20to%20show%20tomorrows%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

HI, I am very new to using access and i have created a report to show due today task, i need to have the same report but to show due tomorrow tasks. Can someone please tell me how to do this??? Is it as simple as changing the expression from this .... =date() to something else??? 

5 Replies
=DateAdd("d", 1, Date())

@Daniel_Pineault thanks! it is now showing tomorrows but also still todays. what if i just want to show tomorrows?

Switch to SQL view and copy/paste the entire SQL statement here for us to review.

@Daniel_Pineault sorry i dont know what SQL view is ? 

@Daniel_Pineault still not getting the correct data on my report for jobs due the following day. i have used this - =DateAdd("d", 1, Date()) which has changed the date that is displayed at the top but does nit display the jobs that are assigned for tomorrow? if that makes since . iv attached a photo Capture.JPG