Search results

Thanks Linq, but same thing happened again. I copied your code and put it in on the onClick line, but again, it is still deleting current + next record. Very odd.

Hello there, I have a strange situation. I have a columnar form with a sub-form based on an updatable query. I've created a delete button on the master form with the intention that if the user hits the delete button, it will delete the current record (like its supposed to, right?). But what is...

You are awesome, that did it!!! Thank you so much for the assistance. :D:D:D:D

Getting Closer!! That worked but it sums over all, I need it to run the sum over the group by Table. Here is the dB:

Thanks. I tried that and same thing same error. Here is the whole query: SELECT qryDining_Plan_Sun.Attendee_ID, qryDining_Plan_Sun.Table, qryDining_Plan_Sun.Last_Name, qryDining_Plan_Sun.[Seat Code], qryDining_Plan_Sun.Att_Count, Sum(DSum("[Att_Count]","[qryDining_Plan_Sun]","Seat Code<='" &...

Thanks for the swift response - much appreciated! I saw that post and tried to replicate it with the single quote before the double at the end (no space between the two, that's just to show in the post). I also tried it before the [Seat Code] and same thing...

Hello, I'm a newb here, so please bear with me (this is also my first attempt with Dsum). I've gone through all the posts and still I just can't seem to get my Dsum query to work without it giving me this: Syntax error (missing operator) in Query section 'Seat_Code<=A1" . I figure I have a...