Search results

Cheers mile, however, this is for SQL! I should'v posted in SQL forum not unless you have an answer

I am trying to count certain criteria in a column. The table looks like thisio: ID ------- NAME ------- DECISION 1 -------- John ------- APP 2 -------- John ------- APP 3 -------- John ------- APP 4 -------- John ------- DEC 5 -------- John ------- DEC 6 -------- John ------- APP 7...

Manmade... tip: it was only erected in the past year and resides in Europe...

Thanks m8. Heres a question: What and where is the world's largest sculpture?

Of course, read again ;)

Hello people, what a pleasent day it is. I was wondering if you could help me with this simple query. Here's my table: tblMain ID-----SalesExec----PPP 001---John-----------0 002---John-----------1 003---John-----------1 004---John-----------1 005---Fred-----------0 006---Fred-----------0...

Hi, I want to run a query that will count and group records into specified income brackets. Similar to the age bracket query here: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=51077 Here is the table in question: tblMain ID ------ Income 101 ----- £12,000 102 -----...

Sorry, stupid me! The funtion is GETDATE

dcx693: I am trying to use this query on SQL but it doesn't understand the DATE function. The exact error is: ADO Error: Date is not a recognised function name Do you know what the translation would be?

I need some advice in designing tables and queries for a credit card application logging system. The initial table design was so bad that it made it really difficult for me to design the all important queries. So I have decided to start from scratch again and redesign the tables. I will...

I cant tell you coz I dont get any errors!

I made the following code to validate dates entered in a text box. The code works fine in Access XP but doesn't work in Access 97, 2000. I have put in down to my bad coding techniques! Here is the code I have used. Can somebody knock me into shape? Private Sub txtDispDate_AfterUpdate() '...

I am trying to make a query that will count records and sort them day by day. Here is the table example: tblMain RecordID ----- DeviceName --------- User ------------- DateTime =============================================== 00001 -------- PC001 ---------------- John Doe ------- 01/01/2003...

Thanks M8

The vb is not liking the BETWEEN bit. Is says: Compile error. Expected Then or Goto? Any ideas

Thank Mile, how do I implement this in VB? Or is it just for SQL? EG. Is it like: IF ME.txtAppDate.Value Between txtDateTimeKeyed And DateAdd("d", 7, txtDateTimeKeyed) then "TO OLD"

Sorry for another Date validation question. I've done some searching but I cant find what I'm loooking for. I need a validation rule that would make sure the date entered was not older that 1 week from todays date. I have a field 'txtDateTimeKeyed' which contains the current date and time...

Did you come up with any ideas?

Thanks mate. That's very kind. For you reference, heres a screen grab of the form itself. All data in the left pane is logged to tblMain and all data in the right pane is logged to tblApplicationErrors There are five combo boxes which all contain the same values. (assuming that there...

Understood, Could you further advise on a better table design? I cant see any other way of storing the data Thanks