Search results

Hi there! I have a [Order Central table] that compiles products from four different categories that employees can order from. Employees using the database will select from four categories on buttons which opens up the order form EX: [Category 1 form]. They enter their order info on...

Awesome! That worked great, thanks a bunch.

Hi CG_London! So one column 1-999 would not be allowed, 1000 is allowed 1001-1999 is not allowed, 2000 is allowed. 2001-2999 is not allowed, 3000 is allowed. I have another column that has to be entered in blocks of 20, 1-19: not allowed; 20: allowed 21-39: not allowed; 40: allowed Any thoughts?

I think the quickest solution (and probably the laziest/least professional) is to: 1.) Remove the Primary Key from your table 2.) Copy and paste the data into an excel file or another blank table 3.) Delete all the data in the original table 4.) Delete the autonumber column from your pasted...

Hi there! I am trying to make a quantity column in my table only allow input with intervals of 1,000! Any suggestions? -Nick

Hi there! Not sure what your SQL statement looks like but you'll have to add With clause into the mix! Here's a link regarding 'With Clause's' if you need it: technet.microsoft.com/en-us/library/ms175972.aspx Sorry it's not a hyperlink, not enough posts yet!

Yeah I noticed my mistake right after I sent that reply! Update's nearly instantly right now. Thank you :)

Here's what my final statement ended up looking like to whoever is interested UPDATE [DSL Carrier CLLI's] INNER JOIN [Customer NPA-NXX's - ADSL - Test] ON [DSL Carrier CLLI's].DSLCarrier = [Customer NPA-NXX's - ADSL - Test].[LowCap(L)].Value SET [Customer NPA-NXX's - ADSL - Test].[LowCap...

Thank's so much for the response Pat! This works great, a little slow but it gets the job done!

You tables and relationships look spot on in regards to how the info will be displayed. Here is my suggestion: 1.) Create another table (lets call it tblNew) with Surgeon Name & Equipment Needed in the columns. a.) Set a temporary variable for whomever the current surgeon logged in is. Ex...

Also, I'm pretty new to this site! Any first-timer pointers you want to give me would be appreciated :)

Hi there! I am having an issue with my lookup function. :banghead: I want the lookup to be performed with criteria based off of the same row that record being selected is on. I wrote typed out the Columns and rows that my queries return, and attached a screenshot as well. Here’s an idea of...