Hello,
My name is Helge and I am looking for some help. I have never used Microsoft Access until a few hours ago and for that reason I hope you can overlook if I sound stupid. I'm trying to follow the instructions shown in this video tutorial (link below). The end goal is to be able to show a countdown timer in a PowerPoint presentation. But I can't seem to get the database in Access 2016 to work. As I said, I never used it before and spent a couple of hours trying to figure out what to do by googling and using the help section to no luck.
https://www.youtube.com/watch?v=PzWVUBslby8
- I have created a table called "TableTargetDate" which basically is a row with two columns named ID and Field1. ID has “1” as a value and Field1 has “2018-02-01”.
- After that I clicked on Create -> Query Wizard -> Simple Query Wizard. From “Available Fields:” I choose ID and Field1 then clicked finished.
- I renamed the thing I just created from “TableTargetDate Query” to “QueryTargetDate”. Not sure if it matters but in the video that’s the name they are using.
- I right clicked on the query and went into Design View -> SQL View.
- I wrote the code in the box from what was shown in the video:
Code:
SELECT Format(DateDiff([“d”],Now(),[Target]),[”00”]) AS days, Format(DateDiff([“h”],Now(),[Target]) Mod 24,[”00”]) AS hours, Format(DateDiff([“n”],Now(),[Target]) Mod 60,[”00”]) AS minutes, Format(DateDiff([“s”],Now(),[Target]) Mod 60,[”00”]) AS seconds FROM TableTargetDate;
When I click on “Run” it opens up a dialogue box and its asking: Enter Parameter value “d”. Regardless if I write a value or not, after I click ok its asking for parameter values for: Target, “00”, “h”, “n”, “s”. Then it says the phrase is either to complex or wrong. Ive compared the code to the one shown in the video several times and I can't see any difference. I's there some connection between the boxes in Design View on Queries that must be done or what?
I would be grateful if anyone, in some easy, way could explain what I need to do to get it to work.