Recent content by gmgenova

Thank you. And no, I have not.

Hi. I have a file where the first name and last name are in columns 2 and 3. Currently, they are both in all caps. I want to change it so just the first letter of the first name and the first letter of the last name are in caps. I have some code below but I need it modified to only include...

Since my query is in Access, I ended up doing this to get the date variable I needed: AND (([dbo_RX Reporting].Period)=Format(DateAdd("m", -1, Date()), "yyyymm"))

I am an SQL novice. I am going to be putting some of my access queries in macros so I need to automate some of the dates I have in my SQL statements so no user intervention is required. I have researched but have not found what I need yet. Here is one of my SQL statements. I just need to have...

I ended up saving this query and making a new query that refereed to this query and sorted the field in the new query. Thanks for the help!!

I like this Andy. I tried it though and get 'Syntax error in FROM clause.' Thanks.

So mine should look like this? TRANSFORM Sum([dbo_RX Reporting].Price) AS SumOfPrice SELECT [dbo_RX Reporting].[Master Drug Name], Val(DSum([dbo_RX Reporting]).Price) AS Total FROM [dbo_RX Reporting] WHERE ((([dbo_RX Reporting].[Therapeutic Class]) Like "*Analg*") AND (([dbo_RX...

No, because the field I want to sort by is an aggregate field. TRANSFORM Sum([dbo_RX Reporting].Price) AS SumOfPrice SELECT [dbo_RX Reporting].[Master Drug Name], Sum([dbo_RX Reporting].Price) AS Total FROM [dbo_RX Reporting] WHERE ((([dbo_RX Reporting].[Therapeutic Class]) Like "*Analg*") AND...

I have a crosstab query that has an aggregate field in it that I can not automatically sort when the query runs in Access. I am making a VBA macro and am trying to run the query in there and also sort that particular field. I am not very experienced with VBA so I am getting errors. I am just not...