Search results

Thanks for that. Both suggestions look like they'll give me what I need. I'll give it a try at work tomorrow and let you know how I get on. Many thanks.

I'm analysing phone calls and costs for my employer. I have a table of around 8 million call records giving amongst other things - DistanceBand (eg Local, National, International) - Time Band (eg Daytime, Evening, Weekend) - Duration of call in seconds - Cost of call As you would expect, we pay...

Thanks for that SOS. Cheers.

Many thanks for the advice. I'll give it a go. Best wishes. Mark

I'm sure there's an easy answer to this but its stumping me right now; I have a checkbox on a user input form. If the user ticks the checkbox, I want the query to return all records. If the box is unchecked, I want the query exclude certain records. I have used : Like...

I have a database of timesheet bookings. The relevant fields are WeekNumber, HoursQuantity and Category (Direct or Indirect). I am trying to create a graph from a query showing Week Number along the x axis and summary bars of Category on the chart then Hours on the y axis. This works fine when I...

Hallelujah! I had a look at your attachment and I was missing the 'Like' at the beginning. It now does exactly what I wanted. Many thanks again. Have a good weekend. Mark

Didn't see that sorry. I can't look at it at the moment due to my employer's firewall restrictions. I'll have a good look tonight when I get home. Many thanks. Mark

Re: Query linked to Form with empty value Thanks. I've tried that but it still returns no records. I have also tried using Like "*" as well as just "*" but that doesn't work either.

Hi, I have created a query linked to combo boxes on a user input form with [forms]![inputform]![comboxx] as my criteria. This works fine until one of the combo boxes referred to is empty. In this case, I want to return all records, but the query returns no records at all. I have tried using...