Search:

Type: Posts; User: Leesha; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    3
    Views
    956

    Thanks for the link! What a great guide. I had...

    Thanks for the link! What a great guide. I had already done the google xml file so that is all set.

    Leesha
  2. Replies
    3
    Views
    956

    Hi, I have a website that I would like to have...

    Hi,

    I have a website that I would like to have as much visibility as possible since its selling a product. I don't at this point want to invest in the cost per click plans that Google, Yahoo,...
  3. Replies
    4
    Views
    682

    Hi! I'm not doing it from the wizard, however...

    Hi!

    I'm not doing it from the wizard, however I do have all of the rows, columns and values identified. Nothing I try works. I use crosstabs all the time so this one really has me stumped. It...
  4. Replies
    4
    Views
    682

    Hi, I'm trying to run a crosstab query that...

    Hi,
    I'm trying to run a crosstab query that uses another query to provide the information. The first query is sorted by a a control [txtYear] on frmReports. This works fine. This query is a query...
  5. Replies
    3
    Views
    395

    Hi Andrew, The form was open so that is why I...

    Hi Andrew,
    The form was open so that is why I wasn't sure about adding in the tabbed page. I went back and hunted and found that at somepoint (God only knows why or when) I set the bound column to...
  6. Replies
    3
    Views
    395

    Hi, I'm trying to filter a query based on a...

    Hi,

    I'm trying to filter a query based on a combo list control [cmbIndividual] that resides on [pageCensu] on frmReports. When the I run the query using the following sql it comes up null:
    ...
  7. Replies
    3
    Views
    3,442

    LOL! When it comes to me with sql Server don't...

    LOL! When it comes to me with sql Server don't assume anything. It's only by luck when I get things to work. I used Wendell's sql and it works as long as CustomerID and Paid are not in the query. ...
  8. Replies
    3
    Views
    3,442

    Hi, I have the following formula which is working...

    Hi, I have the following formula which is working fine:
    SELECT SUM(ItemPrice) AS [Total Price], CustomerID, SUM(SalesTax) AS [Sales Tax]
    FROM tblShutterbugOrder
    WHERE (CustomerID =...
  9. Replies
    7
    Views
    1,120

    Hi Pat! I'm running it in sql, not access. I...

    Hi Pat!

    I'm running it in sql, not access. I need it for a asp.net web page.

    Thanks,
    Leesha
  10. Replies
    7
    Views
    1,120

    Hi, I am running query in sql server 2005 and I...

    Hi,
    I am running query in sql server 2005 and I need to have it return the [customerID] and the [OrderDate] as a string with date in mm/dd/yyyy format but no slashes. An example of how it would...
  11. Replies
    2
    Views
    519

    Thanks! That is what I needed!! Now I can see...

    Thanks! That is what I needed!! Now I can see why I was getting zeros.

    Leesha
  12. Replies
    2
    Views
    519

    Hi! I have a report that has control...

    Hi!

    I have a report that has control [timelysynchtooffice] which will have results of either "Timely Submission" or "Late Submission". There is a corresponding control [sumoftotal] that gives the...
  13. Thread: Filtering Time

    by Leesha
    Replies
    7
    Views
    607

    Hi Hans! The first one worked perfectly....

    Hi Hans!

    The first one worked perfectly. Thanks to both of you for the explanations. My gosh is time complicated!!!

    Thanks and Merry Christmas,
    Leesha
  14. Thread: Filtering Time

    by Leesha
    Replies
    7
    Views
    607

    Hi Hans, I got an OBDC error stating something...

    Hi Hans,

    I got an OBDC error stating something about using the convert function to run this query. This database has a few links to sql tables and don't you know this is one of them. I can always...
  15. Thread: Filtering Time

    by Leesha
    Replies
    7
    Views
    607

    Hi, I have a field in a query called...

    Hi,

    I have a field in a query called [senttoSAM] that is a date/time field and is set to general date, so that it shows the date and time. I need to do a filter that will filter out any times...
  16. Replies
    4
    Views
    458

    OMG!!! That was simply too easy! I love it! ...

    OMG!!! That was simply too easy! I love it!

    BTW, I didn't get an email for either of these two responses. They aren't in my spam either.

    Thanks!
    Leesha
  17. Replies
    4
    Views
    458

    Hi! I have a report that when it loads I would...

    Hi!

    I have a report that when it loads I would like results to change color based on the value. So if [1] > 25 then the color of [1] would be red adn it would be bold. Is this possible and if so...
  18. Hi, I've got a internal website built which is...

    Hi,
    I've got a internal website built which is running on Small Business Server 2008. The users are able to access it provided they log onto it remotely from outside the office. If they are in the...
  19. Replies
    3
    Views
    459

    That worked perfectly!!! Thanks! Leesha

    That worked perfectly!!!

    Thanks!
    Leesha
  20. Replies
    3
    Views
    459

    Hi, I'm trying to figure out total time in a...

    Hi,

    I'm trying to figure out total time in a query for a time sheet. I have [starttime] and [endtime] which the user enters data in. The I have [Totaltime] which is a formula. I tried...
  21. Replies
    41
    Views
    2,008

    Perfect! thanks!

    Perfect! thanks!
  22. Replies
    41
    Views
    2,008

    The only problem with this recent code is that...

    The only problem with this recent code is that the row that has cells that are blank(not null) is filtred out leaving only the rows with names. Normally this would be fine but what I run into is...
  23. Replies
    41
    Views
    2,008

    Thanks to both of you! The database is...

    Thanks to both of you!

    The database is actually pretty clean in that at the present time there are no spaces in the first and last names that I can tell anyway. There is one row that has no data...
  24. Replies
    41
    Views
    2,008

    Hi Francois! Yes, there are no values in those...

    Hi Francois!
    Yes, there are no values in those fields. In that instance, I need the comma not to be inserted, or I should say, the fields not to be joined together. It would ONLY be when nothing is...
  25. Replies
    41
    Views
    2,008

    Well I told you I'd be back. I'll bet you didn't...

    Well I told you I'd be back. I'll bet you didn't figure it would be so quickly! The code I'm using works great with the exception of when LastName, FirstName and MI are all null. Then the query...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4