Search results for query: *

This works perfectly! I didn't know you could use more than one iif like that. That is much better than if..then..elseif. THANK YOU!!! You saved the day. Thanks, Brian

I need some help with some code. I am new to this. Can someone please help me. How do I do this? the table is apparel the field in my table category the contents of the field category are accessories and 2004 collection. There are about 72 items, some have accessories and the rest are 2004...

I want either the first field or the second field to match what the user enters, there may be a chance that both fields do match, but that doesn't matter if it looks at each field independantly, right? I don't know much about sql. I did do view sql mode to show you what I have now. Where will...

I have dates in 2 columns. I would like to have the user input the date they are searching for. like [Enter Date]. Then using the date that was entered, show all of the records that matched the date they entered from both the first date column and the second date column. Also, I would not...

The query I am trying to make is as follows. I have data in columns, each column is a month and one is the year. See example below. Year Jan Feb March Apr May Jun Jul Aug Sep Oct Nov Dec I have now when making this query to select the year, I put in the parameters as [Enter Year] and when I...

I am exporting an access 2000 database to mysql through odbc. Everything exports ok. If I then link the mysql database from access 2000 through odbc, the data type is memo, it was originally text. The original datatype in the access 2000 database is text. Why is mysql changing the data type...