Recent content by thouston

OK, I have managed to get it to work. It seems that the only way it will work is if I not only use a day number rather than an actual date value, but also convert the country code (2 letters) to an integer code. CumArea: DSum("[TEST].[Area2]","TEST","[TEST].[Daycount]<=" & [TEST].[Daycount] &...

According to the stats I was last here in 2004...how time flies...:D I have a database containing dates and areas that I want to make a cumulative total of over the year. The relevant fields in my small test database look like this: A_Date Area 01/01/2002 0.1 02/01/2002 0.56 02/02/2002 23.5...

"because you only type in the date field one date which is for present day and only one date is allowed to exist I would do it like this:" (smercer) Unfortunately the date entered would not necessarily be for the present day (eg they would fill in the paper log book over the weekend but not get...

It's a long, long story and I would not be doing it this way if I were starting out fresh... In the old days people from a variety of outstations filled in a daily record and submitted a monthly paper form. The data entry system was then written so they could enter the info daily and submit it...

Does anybody have some more ideas on this - I'm not a VBA expert (only use databases for the storage and querying facilities normally). :confused:

I am developing an Access front end for people to enter meteorological data. The user goes into an introductory screen in which they type in the date of the assessment. They then go into the data entry screen. What I want to do is to make a check in the data; if that day's data already exists...

You are going to have to formulate some rules for what to do in the event of a tie. For example, in your original illustration, no 66 was first in the first heat, third in the second, while no 99 was third in the first heat, first in the second. I would put these as equal. Would you use a random...

I'm guessing that all those dates might be slightly differently specified in the underlying database (eg some date/time, some just dates perhaps). If you can easily lay hands on the info, it might be helpful to get the data type specs. Otherwise I suspect you'll get there pretty quickly by trial...

I think your problem is using the Append query to reproduce your tables. Try using either a Make-Table query or Get External Data (from the File menu) to do it instead. Good Luck!

I'm not quite sure why you would want to have these tables both separate and altogether in a new table. There are various ways round your problem but they all really depend on what you are trying to achieve. If you give some more details I'll try to help!

You'd want syntax that went somthing like this: SELECT etc etc FROM dbo_F_TASK_TIME WHERE (((dbo_F_TASK_TIME.TT_STARTED)>=[start date]) AND ((dbo_F_TASK_TIME.TT_STARTED+1)<=[end date])); Check out the brackets etc, I haven't tested this! I reckon that's probably the simplest way around this...

Make a new query that calls the one you have already created containing your calculated subtotals. You will now be able to group by orderID and total your subtotals.

Hmm, could be that your remote server doesn't support exactly the same SQL syntax, or has a few cunning differences. It seems that it doesn't recognise the "datevalue" command. Check to see whether there are any synonyms that might work. Otherwise you might have to do something clever like add a...

The odbc could be part of the problem. What is it linking to (eg. Oracle, what version etc?). At what stage is your query failing, if you split it into 2 parts - the datevalue function or the grouping?

That's funny. I tried your syntax on my test DB and it seems to work fine, even with all the brackets reproduced as you wrote the query. The only thing I didn't test was your join (obviously I don't know what's in your other table). All I can suggest if you can't make it work is that you do a...