Search results for query: *

I've got a spreadsheet with the following three columns: Previous Day | Today | Month to Date | I'm constantly changing the data in Today and would like it to keep adding the information into the month to date. Can anyone help!! Thanks, Kirsten

Thanks Bob for your reply I did a search but i'm afraid that I am unclear as to my first step. Here's what I need to do. I have a database of customer info like Name, Address, $ amount so on.. I need to import these fields into a standard letter to around 500 people and then e-mail it. I...

Can anyone tell me how to do a mass e-mailing - mail merging data into the e-mails from a database. Any help would be appreciated. Thanks Kirsten

I'm trying to group a date and time value by just the date value. I've set the column to group by in design view do I need to specify criteria? ELECT [Last Called State - History Table & HistCampaign Table].CampaignID, [Last Called State - History Table & HistCampaign Table].CustomerID, [Last...

Thanks

Can anyone tell me the formula to count the following: 38059 38590 38506 38059 I would like it to count "38059" and "38590" = 3 Please help Thanks, K

CommentCalls.Code contains codes that are equal but case sensitive. I have linked this table to another table to show description as the original file has none. The problem that I have is that it pulls not only the description for the lower case codes but also for those equal to it in upper...

Hey Rob Thanks for your reply only I have many codes that use both upper and lowercase such AB aB not just sm and sM is there not a way to have my querie use my table to read my linked file exactly as it was inputted. Here's the queries I'm using SELECT Commentcalls.Code...

Please help, I have a querie that uses a table of codes to read a linked file. The problem I'm having is that some of the codes can be both sM and sm of course these codes are unchangeable. Is there a simple way to change either my table or my querie to recognise the difference. Thanks Kirsten.

Got it!! Thanks Duane.

BNP Mike, Thank you for your kind response. I have now after looking in help figured out the above problem. I know how to use access to a certain degree, I'm just struggling with some of the terminology. Thanks, Kirsten.

I have a report I'm running & I've checked my database and it has fewer records in it that my report says it has. My total & Grand total does not match my detail records always by one. Detail records is correct totals are worng. My report is based on the following query:- Can anyone...

Yes, Thank You. Is there any way to automate this to print on a certain date and time? Kirsten.

Thanks for your help - how brilliant you both must be. I expect you both thought you were being cool. Oh dear, Oh my.

Run selects??? Kirsten.

I'm linking a txt file and trying to set crieria to remove certain records can anyone help me with this? Thanks, Kirsten.

Hey Ken, Cannot link to a .txt file don't know why states that microsoft jet engine could not find the object. I can do a cut and paste ok. I'm actually more interested in the query to export to mail merge in Word. Thanks for answering, Kirsten.

Hi, I need to import a .csv file into Access and then automate a process whereby it would print a letter from a mail merge within Word. I realise I would have to import the .csv file and that there is no way to automate the process, but would like it if that was all I had to do. Can anyone...

Hi, Can anyone tell me the best way to automate a mailing labels report. I need it to re-check my data source and then print the labels on a certain day and time. I'm new to Crystal and cannot find anything in help. Thanks, Luke.

Is it possible using crystal or access to automate (Date and Time) a mail merge to word using a file index data source? If so can anyone help me with how to start? Thanks, Luke.