A
antonyliu2002
As a practice, I am working on a todo list web application.
I have MS Access database called Tasks.mdb, which contains a simple
table called Tasks that looks like so:
TaskID Name Completed
0 Create DB Yes
1 Build Web No
2 Enable AJAX No
3 Write Doc No
In the video, they have a SQL query like this:
Select TaskID, Name, Completed from Tasks where Completed=@IsComplete
It seems that IsComplete is a function that'll return either "Yes" or
"No". So this single query is pretty much like two queries below:
Select TaskID, Name, Completed from Tasks where Completed="Yes"
Select TaskID, Name, Completed from Tasks where Completed="No"
I need to use this feature with ACCESS, but it looks like ACCESS cannot
recognize "@".
So, how do we do this in MS Access? Anyone can give a hint? Thanks.
I have MS Access database called Tasks.mdb, which contains a simple
table called Tasks that looks like so:
TaskID Name Completed
0 Create DB Yes
1 Build Web No
2 Enable AJAX No
3 Write Doc No
In the video, they have a SQL query like this:
Select TaskID, Name, Completed from Tasks where Completed=@IsComplete
It seems that IsComplete is a function that'll return either "Yes" or
"No". So this single query is pretty much like two queries below:
Select TaskID, Name, Completed from Tasks where Completed="Yes"
Select TaskID, Name, Completed from Tasks where Completed="No"
I need to use this feature with ACCESS, but it looks like ACCESS cannot
recognize "@".
So, how do we do this in MS Access? Anyone can give a hint? Thanks.