I have a "linked table" that connects to a SQL server VIEW. All of the number fields are coming into ACCESS as text rather than numbers. I doesn't seem to happen when I link to a table on the SQL server, only when I use a VIEW.
Anybody know how to fix this?
I am new to Access, but I am now comfortable with the method of filtering a continuous form by a combo box-driven macro. Can someone tell me how to do this for multiple filter criteria? For example, filter my continuous form by both product name AND year AND month using combo boxes at the top...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.