Search results for query: *

Hi, I am trying to set up a database that will calculate the reward offered to member for the sale of their seat. this is based on three things: a) member category - A, K or J b) seat category - P, G, S or B I have a table of seat details that lists the seat category, another table that has...

Hi all, I have a form where the user will enter a ClientRef (txt) and I have a text box I want to lookup that client ref and return the count of client ref from a query Count of Original Seats. I have tried the following but I just can't get it to look up! = DLookup("[countofclient ref]"...

Hi I haven’t used Access for about 3 years so apologies, I’m very rusty. I have been reading the threads to deal with crosstab queries, however I just can’t get them to apply to my data. I have a query [Seat Re-Sale Data] holding all the data of resold seats on a match by match basis. The...

Hi I'm using Word 2002 and creating a Project template. I have used ask and ref fields for the information to be entered and they work fine, however, when i try to record a macro that prompts for the ask fields, i cannot stop recording until they filled out - which obviously is useless...

Hi, I have 3 tables. I want to delete all records from the Reply_work table where they match the Call_req table and the last mod date in the call_req table is later than the date in the tbl_refreshdate. It used to work, but for some reason i am now getting the above error. Any ideas? the...

Hi I have a table that has fields containing responses for questions Q1 through Q14. These fields contain numbers 1 through 5 or are blank. I need to query each field to count the total number of 1s, 2s, 3s etc. and total number of blanks. Is there a way to do this through the one query? Or...

HI, Does anyone know if there is a work around for the 255 character limit in Access fields? thanks Nikki

Hi, I'm running a delete query based on 2 tables (requesthours and refresh_date) and deleting based on requesthourse.last_mod_date being greater than refresh_date.date. It works fine in the previous however I get the error Could Not Delete from Specified Tables. DELETE tbl_RequestHours.*...

Hi, I have a query that works fine, however I was wondering can you use select distinct in Access SQL? thanks in advance

I have a database that has a reference number (job number) and another table that has the activity log for that job. Is there a way i can run a query where it will only extract the latest activity log entry for that job instead of the entire activity history? thanks