Search results for query: *

HI Darylle, At this stage tables are as follows: table - member category Category - Adult, Concession, Junior code - A C J table - Rewards Member Category P G S B Adult $19.18 $17.51 $15.68 $12.53 Concession $15.22 $13.90 $12.44 $9.94 Junior $6.02 $5.50 $4.92 $3.93 So I'm...

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

thanks for your replies. ProgramError, I tried putting a bracket - still no change, also did a build event using the field names - still no result. PHV - the sql is as follows: SELECT [Client Data].[Client Ref], Count([Original Seat Data].[Client Ref]) AS [CountOfClient Ref] FROM [Client...

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

ok. so after spending most of the day banging my head against the wall trying to transcribe all this data, I refuse to believe i can't do it in a query. could anyone please post how I should write this? thanks in advance

Thanks for your help PHV. I still can't get it to work, it's so long since I've used any of this stuff I think I've gone right back to scratch knowledgewise. I think I'll just do a manual transcribe. cheers

Hi, this is what I came up with (fully expecting to be incorrect...): SELECT [Client Ref], Concatenate("SELECT [Game] WHERE [Client Ref] =""" & [Client Ref] & """) as Event FROM [Re-Sold Seat Rec Data] Unfortunately it keeps coming up with a syntax error and I'm completely lost. sorry to...

Maximum number of games will be 6. Obviously, it may be any number up to 6, but I just need to extract the names of the games they sold for. thanks so much for your help

the SQL is: SELECT [Seat Holder Data].[Client Ref], [Re-Sold Seat Data].[Game], [Re-Sold Seat Data].[Reference], [Re-Sold Seat Data].[Barcode], [Re-Sold Seat Data].[Area], [Re-Sold Seat Data].[X Sect], [Re-Sold Seat Data].[Row], [Re-Sold Seat Data].[Seat], [Re-Sold Seat Data].[Sold], [Re-Sold...

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

thanks very much for that. made my day :) nikki

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

I did look in help and it only referred me to a visual basic module. I was actually wanting to use it in an SQL statement.

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

Hi, Thanks for your suggestion. I tried the MAX function, however this still produced the full activity log for each job. I've attached the sql that i'm working with. What I need to pull out is the last_mod_dt from the ahd_act_log table. SELECT tbl_outstanding_problems_work.Name...

I tried as you suggested and it returned the most recent record, however it was only for one job. I probably didn't explain the problem properly the first time so i'll try again: I have a table with about 30,000 job numbers. Another table holds the activity logs for each job. On average...