Re: Sales Report Grrrr


Cool thanks man! That worked too.

I have been thinking. I would like this data in a mysql database. And
be able to do the exact same query, but with a sql query.

Then display the results on a website, or something...

Anyone have any sql experience. I should probably blow the dust off
some of my sql books and start learning. That and my php book.
'
I know I know, I should be posting this on a SQL forum...

If you guys even need some dental advice, go to
http://www.dentalcom.net

I made it.
:)

The reason I am doing this is to help someone out. We are experimenting
and having some fun. If I could find a SQL way to do it, then I get a
free box of donuts!

LOL.


--
jshafer817
------------------------------------------------------------------------
jshafer817's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=25758
View this thread: http://www.excelforum.com/showthread.php?threadid=391707

.

Relevant Pages

  • Re: Equivalent of Get Next Extended to retrieve only unique keys?
    ... The only real "extra" stuff is pertaining to SQL query optimization. ... Bill Bach wrote: ... Retaining the ability to filter on multiple>> items would probably ...
    (comp.databases.btrieve)
  • Re: Setting a Default Value
    ... the make the Sql call from within Application_Start in Global.asax. ... the query string value each time I needed to ... going to assign the default value through a database query. ... run the following SQL query: select * from table where x = 1 ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: MultiSelect Property
    ... > For Each vItm In Me!lbSelectContract.ItemsSelected ... > Dim stCriteria As String ... >> SQL query). ... >> the multiselect list box appears in the SQL query. ...
    (microsoft.public.access.devtoolkits)
  • Re: Crosstab counting
    ... Michel, thanks for the response. ... I've built the table as shown, ... After reading the syntex sql multiple times, I can see the statement forming ... The SQL query is the same as yours: ...
    (microsoft.public.access.queries)
  • Re: Report in VBA - FilterName or WhereCondition
    ... strWhere clause as you advise. ... If you use un-bound controls in your sql query, ... strWhere in the filter parameter of the report, the defense is that you can ...
    (microsoft.public.access.modulesdaovba)