# ASP & Access - using variables in query?
**URL:** https://forum.kirupa.com/t/asp-access-using-variables-in-query/57634
**Category:** programming
**Created:** [July 14, 2004, 9:21pm UTC](https://forum.kirupa.com/t/asp-access-using-variables-in-query/57634 "2004-07-14T21:21:40Z")
**Posts on this page:** 3
**Page:** 1
### Author:  [@CommanderCool](https://forum.kirupa.com/u/CommanderCool)
#### Post date: [July 14, 2004, 9:21pm UTC](https://forum.kirupa.com/t/asp-access-using-variables-in-query/57634/1 "2004-07-14T21:21:40Z")
just wondering if anyone has any knowledge on using numeric variables in an ASP query to an access database.
basically so instead of being forced to use:
RecordsetHost1.Source = “SELECT \* FROM [events calendar] WHERE HostID=1 ORDER BY StartDate DESC”,
HostID could be a variable use to display the respective page… unfortunately whatever i try i get errors… does anyone know the syntax for writing ‘HostID=n’?
thx,
CC
---
### Author:  [@system](https://forum.kirupa.com/u/system)
#### Post date: [July 14, 2004, 10:02pm UTC](https://forum.kirupa.com/t/asp-access-using-variables-in-query/57634/2 "2004-07-14T22:02:22Z")
```auto
RecordsetHost1.Source = "SELECT * FROM [events calendar] WHERE HostID=" & n & " ORDER BY StartDate DESC"
```
---
### Author:  [@system](https://forum.kirupa.com/u/system)
#### Post date: [July 16, 2004, 8:02am UTC](https://forum.kirupa.com/t/asp-access-using-variables-in-query/57634/3 "2004-07-16T08:02:33Z")
thanks ahmed, that works like a charm!.. leave it to Microsoft to create a scripting standard written in like a hundred different ways… 😛