Search results

I'd like to take a branch number field, let's assume it is "223" and change it to "223 No Com". Is there a way to add the "No Com" on the end of it like that?

Im looking for something that filters information for 6 months prior to any current, non-specific date. Like it will automatically get the data dated from 6 months ago from june, july, or august, without anyone having to go in an change the date criteria. Below is a non working example of what...

have a query with a field that contains numbers with 3,4,and 5 digits. I want to format it so it displays all as 5 digits by adding 0s to the front of the number. EX: 324 4856 45634 change to: 00324 -4856 45634 Help please. Dont want to do it in VBA either. I would rather build it as an...

Ok, I have a series of 4 queries and I want to shrink it to 3. There is a datevalue function that work in one make table query but not the previous make table query where the date is originally pulled from. datevalue: DateValue([actiondate]) is what I use. "actiondate" has a date and time in...

Is there something I can put into the criteria of a date box to only use the last 6 months. I dont want have have to do this type of criteria: >12/1/2004. I want it to just use information from the last 6 months no matter what the current month is. If anyone knows what I am trying to say...

Option Compare Database '------------------------------------------------------------ ' Pipeline___Trades_to_Access ' '------------------------------------------------------------ Function Pipeline___Trades_to_Access() On Error GoTo Pipeline___Trades_to_Access_Err Dim sNow As String...

I can't figure out how to create a macro that imports a table from one database to another database. Any ideas?

Is there a way to import an excel file and save it as a table witht eh table name including the date/time?

Whats wrong with the script below. I keep getting a compile error: expected: End of Statement '------------------------------------------------------------ ' Test_Locks_macro ' '------------------------------------------------------------ ' autoexec1 '...

Ok. I have a list of numbers in 2 fields. What do I do for the criteria to show the numbers that are not the same for each field. Ex: 693 703<---- 756 756 733 737<---- 733 781<---- 664 664 Both numbers are from 2 separate tables. How do I get teh query to only show the numbers that...

I want to filter out all of the "Not assigned" so that it only displays the numbers in the field.

Is there a way I can get a date/ time stamp for reports. I run a macro that creates a report and converts it to RTF in a server file. I want the name of the report to also contain the date and time modified. Help please. Bowes

Ok. I have a schedule right now that automatically runs my macro I need and sends the report to a certain file. Is there anyway that I could extend this to copy the report and paste it onto an e-mail in Lotus Notes and then send the e-mail? Just trying to eliminate a tedious hourly task. Bowes

Hey. Instead of going back every month and changing the date to the first. Is there a function I can put in the Criteria that will automatically filter for stuff only since the begining of the month. Right now I am using this:>=#5/1/2005#. I just want to to automatically change when a new...