Search:

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

Leesha

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

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

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

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

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

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

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

Hi Pat!

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

Thanks,
Leesha

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

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

Leesha

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

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

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

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

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

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

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

That worked perfectly!!!

Thanks!
Leesha

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

Perfect! thanks!

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

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

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

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