Recent content by jasons

I have a client that adds several hundred records to the backend everyday. This over time caused the system to slow down as the size of the backend became enormously large. I ended up archive a year's worth of records and after compacting the backend it ran much faster. The issue I now have...

Thanks Paul. So based on what you're saying get rid of the AND and go with =Switch([Bonus Percentage]<.97,8,[Bonus Percentage]<.99,10, [Bonus Percentage]>.99,13)

This seems so simple but for some reason I can't get the result I'm looking for. On my form I have a field where the user can enter a percentage (bonus) and based on that percentage a dollar amount is populated in the calculated field (Rate). This is the scale that I'm basing my code off...

Came across a very strange problem. Finished up a six month long database design and finalized the security. Everything checks out and looks good until I try to open the database over the network. Every computer on the network that I use to open the database doesn't ask for the logon and...

Thanks again George. With your direction I was able to build a Union query which resulted in the output I was looking for. To simply things I used a limited set of data and queried on minimal fields and worked on the code until it came out right. The only issue I have outstanding is merging the...

Thanks for the direction George. I tried using the iif function previously but could never get it to work without errors. I assumed it wouldn't do what I needed which is perform a select statement if description = "M100" and perform different select statement if the condition was false...

Hi, This is my first post but I've used your forum many times to get myself out of jams primarily by using the search function. I have a snag the search function hasn't been able to help me with so any direction or help you can provide would be tremendous. I've wrote an access db for an...