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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Jeremy1952
- Order by date
-
Update tables from a Query? Need to resolve ASAP.
If any joins are text to text, the query won't update, even though it works as a select query. Also a join to autonumber must be type "long integer"- Jeremy1952
- Post #3
- Forum: Microsoft: Access Other topics
-
rounding
In Access 2000, you can use the "round" function exactly as you do in Excel: =round([Field],2) in a text box or query returns the value of [Field] rounded to two decimal places.- Jeremy1952
- Post #5
- Forum: Microsoft: Access Other topics
-
concatenate fields for a combo box?
Two points: You can write this exact same formula into the underlying query. This is very handy when it will be used in more than one object and/or the requestor changes what information they want in it. 2nd, I've found that Access will return "error" on a correctly written...- Jeremy1952
- Post #3
- Forum: Microsoft: Access Other topics
-
Is Repair and Compact sequence important?
What is the program you are using to automate the process? I only have about a dozen users but my database inflates ridiculously every night. Appreciate input.- Jeremy1952
- Post #5
- Forum: Microsoft: Access Other topics
