Search results

Didn't consider cross tab as there isn't any other data than the number. Smart. Decided its easier to use the text box. At least it will look something like he wants. GRRR!

:banghead: I have been working away and got the tool working how he wants it. Now he wants it changed...of course. I have one field of data it is a list of numbers. For simplicity The data is like: 1 2 3 4 5 and so on. My boss just sent me a mark up and he is asking for it to display on...

Data for now. Wasn't too worried

This is the data I am working with. Yes its linked Visit Date Visit Time Member ID 2/01/2019 7:56:03 AM 3147476 2/01/2019 7:56:17 AM 3148052 2/01/2019 7:56:18 AM 3148052 2/01/2019 7:57:55 AM 3148235 2/01/2019 7:59:41 AM...

Oh. I am working from a CSV file I was reluctant to normalise it as it adds a potential for error.

Thanks...but back up a bit. So Using my examples... I would have a table with Betty 8.00am Wilma 8.15am Linda 8.30am Call the above tblTimes Then I duplicate these in a second table? tblVisitors or am I misunderstanding this?

Thanks. I just solved it. SELECT qryVisitTime.TimeCut FROM qryVisitTime WHERE (((qryVisitTime.TimeCut)>#3:30:00 AM#)); Was the solution... In code this is "SELECT qryVisitTime.TimeCut " & _ "FROM qryVisitTime " & _ "WHERE (((qryVisitTime.TimeCut)>#" & cboIn "#));" Pesky #

So I have a time in for visitors. The visitors stay for an average of 45 minutes. So if they arrive at 8.00 they leave on average at 8.45. I am trying to count something like: Betty arrives at 8.00 (assumed to leave at 8.45) Wilma arrives at 8.15 (assumed to leave at 9.00) Linda arrives at...

I have a real hard time with time...sometimes it works fine. Others, well not so much is a nice explanation for not at all rhyming with duck. Todays challenge should anyone choose to accept it before I explode is the following: SELECT qryVisitTime.TimeCut FROM qryVisitTime WHERE...

Well if I don't say it … no one else will. And if we don't give self praise then...well it would be a sad world. I use Access for various work tasks to help me do my job. I figure its better than a bit of chewing gum, a used stapler and a milk crate which is our usual company standard for...