Microsoft Access Query Help

Status
Not open for further replies.
Hey guys/chics,

I have a project due in a couple of days and I need a little basic help with Microsoft.

I'm trying to run a Query that only includes records with an area code of (616) or (313). Any suggesstions?

Also, I kind of cheated to run a query that showed only records for March of 1997. I used (03/*?/1997) but I think there may be a better way of doing it.

I know these are generic questions, but I'm just starting to learn this program and need a little assistance.

Thanks
 
This is just off the top of my head:

SELECT * FROM (databasename) WHERE (fieldname) LIKE %(616)%

The LIKE statement depends on how the numbers are formatted, really.
 
Forgotten Ancient said:
Hey guys/chics,

I have a project due in a couple of days and I need a little basic help with Microsoft.

I'm trying to run a Query that only includes records with an area code of (616) or (313). Any suggesstions?

Also, I kind of cheated to run a query that showed only records for March of 1997. I used (03/*?/1997) but I think there may be a better way of doing it.

I know these are generic questions, but I'm just starting to learn this program and need a little assistance.

Thanks

SELECT * FROM tablename WHERE tablename.areacode = 616 or tablename.areacode = 313;

SELECT * FROM tablename WHERE tablename.date BETWEEN #03/01/97# AND #03/31/97#;
 
Status
Not open for further replies.
Top Bottom