Search results

Hi all, I have a cross table query with 1. Looks up 'Date()' for todays appts 2. Looks up 'Date()+1' for tomorrows appointments but when i try to run the query with: =[Forms]![frmmain]![appt3])) in other words just looks at the date in the date field on main form, it returns that the database...

I have a query which tells me when a persons birthday is no matter what year they were born (i.e. based on dd-mmm), but I would like to expand that so I can find birthdays in the week or fortnight ahead, can somebody assist, current SQL: SELECT tblClients.ClientName, tblClients.Address1...

Hi Chaps, Bob, yours brought up every date including and after;I got a data mismatch from yours Pat but was it that i had to transpose information into that dateserial line? Here is my current sql: SELECT tblClients.ClientName, tblClients.Address1, tblClients.PostCode...

Bob, just as a thought, is there a way I could make the criteria so it gave me the birthdays for the coming 7 days

Brilliant Bob, many thanks!

Here is the current SQL now i am just after a way to match the dd mmm to the current date (maybe datepart? SELECT tblClients.ClientName, tblClients.Address1, tblClients.PostCode, tblClients.ContactNumber, tblClients.Email, tblClients.Mobile, tblClients.Birthday...

Bob, what i have done in the query is extract the day and month so i have e.g. 25 jul but now in the query how would i get the critieria to look at the dd/mmm and see that it equals Date()

Hi, I want to record dates of birth but without the year of birth so I can run a weekly query / report of birthdays in a specific week in order to send them an electronic greeting. Is this possible? thanks

Hi, sorry to butt into this but i have the same problem, my query is as below and returns in calendar month order as it should but my report returns alphabetical any thoughts: SELECT Format([tblsales].[orderdate],'mmm') AS [Month], Sum(tblsales.VAT) AS SumOfVAT...

Hi all, has anybody got an answer to this - MS rookie has kindly been helping me so the query now reports the months in calendar order but my report still is in alpha order, any quick fix to this; my sql as below: SELECT Format([tblsales].[orderdate],'mmm') AS [Month], Sum(tblsales.VAT) AS...

Yes, that works, thanks but strangely enough the reports are still in alpha order? As they are a summary report and has a grouping level it automatically defaults the sort to A to Z. PS have just ordered my SQL book!

I now have: SELECT Format([tblsales].[orderdate],'mmm') AS [Month], Sum(tblsales.VAT) AS SumOfVAT, Sum([quantity]*[tblproducts.productprice]+[vat]) AS total, Sum(tblsales.Discount) AS SumOfDiscount, Sum(tblsales.[Shipping&Delivery]) AS [SumOfShipping&Delivery] FROM tblProducts INNER JOIN...

I changed it to 'mm' which returns in the right monthly numeric order but I need it to display the month on the reports?

The whole SQL is as below (same as above I think)! SELECT Format([tblsales].[orderdate],'mmm') AS [Month], Sum(tblsales.VAT) AS SumOfVAT, Sum([quantity]*[tblproducts.productprice]+[vat]) AS total, Sum(tblsales.Discount) AS SumOfDiscount, Sum(tblsales.[Shipping&Delivery]) AS...

Yes, but because the select and group by where mmm when I attempted to order by and format mm, I kept getting an aggregate error?

Strange but the order has reverted back? here is sql that worked yesterday: SELECT Format([tblsales].[orderdate],'mmm-yy') AS [Month], Sum(tblsales.VAT) AS SumOfVAT, Sum([quantity]*[tblproducts.productprice]+[vat]) AS total, Sum(tblsales.Discount) AS SumOfDiscount...

Many thanks for help, worked a treat - if you're a rookie, hate to think what I am kh

Thanks for response but am a little lost by how to incorporate into sql; i have: SELECT Format([tblsales].[orderdate],'mmm') AS [Month], tblsales.ProductName, tblsales.Quantity, tblProducts.ProductPrice, tblsales.VAT, [quantity]*[tblproducts.productprice]+[vat] AS total, tblsales.Discount...

I have the following just to extract the Sale Month: Month: Format([tblsales].[orderdate],'mmm') The months display in alpha order whereby I want them in monthn order for reports, is there a simple way to do this cheers:confused:

Thats great! worked a treat - what i dont get is why do we set the default to 1 in the product fields - is it because it is product id 1 in the products table, i'd have thought the default would have gone into the id field but hey many thanks for persevering John