Recent content by SamG

I couldn't agree more, but all I can do at this point is address the problem at hand and move forward. The fields are short text

there is an entry for each variable but thank you!

Hi all, I am still an Access newbie and was told to figure out why this database is not working. When I figure out one issue another one pops up. Any and all help will be greatly appreciated! One query in this macro keeps giving me the "data type mismatch in criteria expression" error. The...

It worked! Thank you all so much for your help!

Haha! Thanks, but I didn't create this database, my predecessor did, but I'll keep that in mind for future use.

Thank you!

Thank you for the info! Again, total newbie so I didn't know that.

Thank you! This is what I used: Iif([CAPPED SALES]>500000, 500000, [CAPPED SALES]) as PROJ 26WK SALES, but when I go to save the changes I get the following message The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect...

Hi there, I've used Access before but it's been a while so I consider myself a newbie again. I am currently using Access 365 and Windows 10. I am working on some sales analytics and need to cap sales at $500k. I don't want to exclude any sales, but rather I want to do a find and replace and...

Hi All, My name is Sam and I live in TX. I used Access many years ago and my new job has thrown me back into it. I have a feeling I'll be asking lots of questions on this forum! Thanks in advance for your patience and help!