Search results

Stupid I know...but I forget how to update a Field to itself in Uppercase.. Anyone? Thanks!

Thank you for reading this! I am not a spreadsheet person..BUT I have two spreadsheets - each have Employee ID #'s one has emails one does not... How do I "Link" the tables on Employee ID and add emails to the spreadsheet without them. I could do this in Access but this is a solution for an...

Works great! Thanks!!!:D

Would this be applicable to a memo field? The idea is that I would like it to create a stamp before or after each addition to the Memo field... Thanks!

I have done this in the past but it has been sooo long since I consistently used Access that I am in a fog:confused: How can I create a timestamp or series thereof, so that each time data is added to a Memo field there is a date time record created? My goal is to allow people to enter notes...

Probably very simple but I cannot get the syntax right - it has been far too long since I used Access. I am trying to seperate a field NAME from these formats: LAST/FIRST M LAST/FIRST To two fields: Field LAST and field FIRST Can someone please help? Thank you! It is Friday and I want to...

I tried text, didn't like it but it did accept ntext - is this a difference I should be worried about in SQL?

I have an Access form linked to two SQL tables, I had to make a change to the field length/datatype of a field named notes. The form now tells me that the "text is too long to be edited" whenever I try to add data to that Notes field in my form. I went from char to nvarchar... how do I fix this?

Hello, I am really stuck - I have a form of companies with a subform of contacts. In the DB (SQL) the tables are related one to many CoKey to ContactCoKey. How do I synch these so any new contact record automatically gets a "new" ContactKey as well as the related ContactCoKey? Thanks,

Hi! I have corrected this problem once before - long, long ago - but my memory is failing me. I have a main form tabular and a subform(datasheet). When I scrooll to the bottom of my main form and hit the next record button - my subform "rolls up" over the main form, how can I correct this so...

Hello, I am trying to convert data from a standard contacts form into a custom contacts form in Outlook 2000. I have the data mapped to all standard fields and need to reassign it to the custom fields using a VBA module. I have found one example online but have had no luck getting it to...

I know that function and do use it often, but it won't work here because the query is not comparing all values it is only comparing those that are created after the contractdate. I guess a better way to state what I am trying to do is to populate the fields that return no value with 0. I...

I may be misunderstanding. You want to update Table1.Location to Table2.Location if Table2.Location = Lab? But only where Table1.Location = Lost? Is that correct? Also, how are your tables joined?

I am in a bind. I am trying to calculate sales by month, compare those sales to what the client contracted for and look at the result as incremental growth. I can calculate monthly sales from start of Contract Date. I can subtract contracted units per month based on contract date like so ...

Thank you so much! I was able to get the same result this morning but without your syntax help it took me 5 more queries to get to the result! Thanks again.. ksaab

Is there a way in a query to only show a value that is duplicated across more than one record? Example: I have two columns Zip 1 and Zip 2 from two different tables. The tables are linked on city and state - I am trying to show a Zip overlay in a query. I need Zip1 to show only if it has...

I will give that a shot. I think I may have stumbled apon a solution. I created a SQL View with to eliminate some subqueries and reflect an accurate count of call days per user per week. When I roll that up in a similar query it seems to work out. KenHigg - I am going to try your solution...

Yes that is basically what I am trying to do. I would like to find a more graceful way to approach it since at this point I have to add a new Week# to two queries each time I do this.. Thanks!

Yes, the table has a callid, callby, calldate, etc I am trying to roll up the calls per day (callid by calldate) by weeks - to eventually yeild a QTD Avg in weeks. Calculating the Avg Days worked per week is no problem. I just count each day that a user showed call activity and then group by...

I have a query that counts calls by date of call by user I am trying to run an expression to sum the calls by week So far I have something like: Week 1: Sum(IIf([calldate] Between #7/11/2004# And #7/17/2004#,[CountOfcallid],0)) But it is not counting the calls correctly..could someone please...