Search results for query: *

Thank you for the reply. I'm not too familiar with VBA. My goal would be to either auto execute this code when the Database opens (which I would like to schedule daily) or auto execute this code at a specific time everyday. Is there a way to do this through VBA? From my research, the...

Hello, I created a Macro with 2 steps: 1. OpensQuery 2. ImportExportText This worked perfectly during testing on my local machine. However, when I tried to implement on a server downstairs, the importexporttext portion deletes the file I created instead of exporting the data. I get the...

Yes, that is the formula I have been using. I shouldn't have used the "date" format in my last post, that was a bad example. But basically what I was saying was it gives me repetitve numbers since I have dates in 2012 and 2013 So a better example is this: September Week 1 Week 2 Week 3 Week...

Alright so nothing changed from my original post -- but I can add on. So with my first group being month, I added in the DATEPART function for my second group. I also have a third group which groups by team. (There are only 2 teams). Group 1 = Month Group2 = DATEPART(add_date) Group 3 =...

Pete - I tried using the DATEPART formula before I reached out for some help. However, it doesn't produce the results I am looking for.

Thank you for the response, Brian. My report is broken out by month, but not weeks. My second group is the WeekOfYear field but for some reason doesn't populate. I will try and plug away at it. I apprecaite all your help. Bests, Brendon

Alright so I created a table that has dates ranging from 1/1/2010-1/1/2050. I left joined my original table to my "Dates" table. Here are my groups: Group 1. Formula = monthname(month({v_ticket_and_returns.add_datetime})) Group 2. Date field from my "Dates" table ---Then I would sort this...

Yes, I believe I could create a temp table in one of my databases in SQL Server. How would the joins work though?

Hello, I I am looking to compare Sales from the 2012-2013 season to the 2013-2014 season. Is there a formula I can create that matches week numbers from this year to the previous year? I'm looking to set up a manual crosstab. Here is an example: 2012-2013...

Thank you for your reponses. I had to log off the network to delete the .ldb file and then set up my macro. Cheers, Brendon

Thank you for the quick response. Do you know what this means. "You cannot delete the file because it is open in System

Hello, I have a simple Macro I created and tested on my computer. It's using an OpenQuery macro and an ImportExportText macro. I need to set these up on the production database that is located on a remote server. When I log into the remote server I switch my production DB to "Exclusive." I...

I appreciate your help but I figured it out... All I did was create a batch file using this path: "S:\DATA\AcsData.mdb" /x MasterAccessToImport Thanks again!

Alright I tried your first suggestion and still nothing. I also tried this: "C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft Office\Msaccess.exe" "S:\DATA\AcsData.mdb" /x MasterAccessToImport I feel like I tried both of these yesterday too, since I have been messing around...

Hello, So I have an ImportExport Text macro set up in an Access Database. I am trying to find the best way to run this automatically, once a day. From the research I've done over the past few days, it seems like people have been using the Task Scheduler to automatically open up an Access DB...

It's because if that cust_first_name field is NULL then primary code is always going to be 'y'. So it's never true that cust_first_name will be NULL and primary_code will be "N". It's alright anyways -- I ended up working it out using different fields. I appreciate all the input though...

So in other words, if first name is NULL, I want the first and last name of the Secondary contact (primary_code = n)

That won't work because I only want to pull the secondary contact if the first name is null.

Hello, I am new to using Crystal Reports and quickly learned that the syntax is different from SQL Server. I was wondering if there is something similar to a where or having clause. I created a formula: IF isnull({v_cust_name.name_first})then {v_cust_name.name_last} else...

SELECT AT_trans_for_emailTrigger.email_addr,AT_trans_for_emailTrigger.inet_event_description,Convert(nvarchar(50), v_live_inventory.event_date,(101)) as event_date,right(CONVERT(varchar, v_live_inventory.event_time, 100),7) as event_time,AT_trans_for_emailTrigger.add_usr...