Search results

Thanks. Will give it a try.

Now I get it. =) Further to that, instead of using format(), format$ functions which turn the data into text representation, what function could be used in order to retain the date format? Is there a site that I could learn about these functions and how to use them?

If you don't mind me asking, what are strings? There are actually some format$ functions used. How does format$(), format(), date$ used? The query was created using wizard and I'm not familar with these.

I have a query which sums up certain fields by months (values and quantity fields). The query was created via access wizard. I need the output of the query to draw a graph via Excel by using "Get External Data" function (I got tonnes of problem with access drawing graphs). The query somehow...

How about using Like "*[a-z]*" in the criteria row within query? That should fix it.

Thanks. Got it!

care to elaborate further? how can i rectify it?

Aaaarrrrggggghhhhh - Date Sort SOS! I'm trying to sort a date in a query but it's being sorted alphabetically instead. The query is linked to an excel file via a table. In the excel file, the cell format is set as date format but once I grouped the table by month (via query), it's converted to...