Search results

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...

The design view grid would look like this: Field:____|FieldA____|FieldB____|FieldC____|FieldD Table:___|XXX______|XXX_____|XXX_____|XXX_____| Sort:_____|_________|_________|________|_________| Show:__|_________|_________|________|_________|...

You don't have to resort to SQL/VB - you can do it in the query design window. Put "A" and "B" in the criteria row in their respective fields on the same line (AND criterion), and the "C" and "D" both on a different line (OR criterion). This may give you some unexpected results (though it's...

If you specifically want to find records that aren't in table 2 then when you've joined the appropoiate fields, change the join type (double click on the link) to include all fields from table 1 and those from table 2 where they also occur. Then you can select all the fields from table 1, using...

When you say "nothing comes up" do you mean the query fails or that it doesn't give you any results? If the second, check that the start and end dates for your query actually include some of the data from your database. If this isn't the problem, check that you are inputting the criteria dates...

Make a new query selecting fields from your original table under the same criteria you used to append data to the new table. Change this to a "delete" query and it will delete all those rows. (If you're unsure about what you're doing, make a backup of your table first just in case...:) )