Search results

Looks really nice, thanks a lot bud!

Sorry about the delay pal. Because my database is quite unclean (Lots of test queries etc) I quickly made a small replica of the problem I've encountered. Set up 2 tables with relationships; Customer/Booking both with some dummy data and a query which is identical to the one i'm currently...

Thanks a lot pal, I'll do it later when I get home.

Yeah I changed the field name to 'FirstName' in the customer table. The SQL below again produced another syntax error. Total: DSum("Price","CurrentQuery","CustomerName ='" Tables!Customer Table.CustomerName & "'") . This is the only SQL I'm using for this Query, other than that it's all...

Just one error to the next! Tried it and have received, for the first time, this error message: "The expression you've entered as a query parameter produced this error: Microsoft Office Access can't find the name 'Enter Name' you've entered in the expression" (I definitely entered the correct...

Thanks for speedy response. I attempted to enter the new code: Total: DSum("Price","CurrentQuery","Customer Name ='" & [Customer Name] & "'") but I got: Syntax error (Missing operator) in Query expression 'Customer Name ='John". Appreciate the help, thanks again.

Hi everyone, I'm not particularly fluent with Access so do excuse amateur terminology, explanations etc. Anyway; I've been setting up a Booking system through MS Access, to run alongside a PhP server. The Database includes information as you'd expect, Customer info, booking Info etc. My...