Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. gmgenova

    Change case of specific strings (columns)

    Thank you. And no, I have not.
  2. gmgenova

    Change case of specific strings (columns)

    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...
  3. gmgenova

    Using date variables in sql statements

    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"))
  4. gmgenova

    Using date variables in sql statements

    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...
  5. gmgenova

    Run query and sort

    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!!
  6. gmgenova

    Run query and sort

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

    Run query and sort

    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...
  8. gmgenova

    Run query and sort

    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...
  9. gmgenova

    Run query and sort

    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...

Part and Inventory Search

Back
Top