Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Need help with coding - if...then..elseif statement?
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...- piper3d
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
-
find records with same date in 2 columns
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...- piper3d
- Thread
- Replies: 3
- Forum: Microsoft: Access Queries and JET SQL
-
Query multiple columns, but only show chosen columns by year and month
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...- piper3d
- Thread
- Replies: 1
- Forum: Microsoft: Access Queries and JET SQL
-
access to mysql datatype
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...
