| Forum Home | ||||
| PC World Chat | ||||
| Thread ID: 84816 | 2007-11-19 23:54:00 | Microsoft Access Query | R2D2 (12631) | PC World Chat |
| Post ID | Timestamp | Content | User | ||
| 613163 | 2007-11-19 23:54:00 | I have a list of names in a an access database table. one field is Date of Birth I want to do a query that can draw out all the birthday's for a particular week. eg week52 About 150 names in the database so some days will have none. Any ideas? |
R2D2 (12631) | ||
| 613164 | 2007-11-20 00:11:00 | SELECT [Date of Birth], Name FROM <Table Name> WHERE [DAte of Birth] like Birthday; Birthday being a varable |
beama (111) | ||
| 613165 | 2007-11-20 01:59:00 | Ok I got it working great. A LOT different to that, but it works. Thanks for the info though. | R2D2 (12631) | ||
| 1 | |||||