Search results

SO I would put the function into the criteria and set it equal to false? I'm trying to construct the query but its not working. The update query will not allow me to use the function in the field name

Hello I have a field that is text format. However many of the records in that field contain numbers. I want to delete all the records that are numbers in this text field, leaving only records with textual data. is this easily possible? Thank you

DONE spanks you very much

Hello I have a field in a table that is comprised of mostly numerical data but some records are text. I want to convert this field to numerical only and make a new field to put the textual data in. However converting the field will delete the textual data. What is the easiest way to convert...

Hello I have a report with 4 sub reports. I want to center them so it looks nice. IS there a way to easily center objects in the middle of the page? thank you

Alright I got it Thanks dude!!

Hello I have an append query that currently looks like this http://i.imgur.com/PYHxqjs.png?1 This query automatically adds the machine parameters for a product code and lot number into the running condition log. This is so the user does not have to manually go in and tediously select each...

Thank you! Now how do I apply to this a report?

Hello I have a query that is returning running conditions for a machine over multiple shifts. the table is set up like this date shift parameter condition 09/13/13 1 front 500 09/13/13 1 middle 450 09/13/13 1...

What you are saying about my parameters table is making obvious sense to me now. Thank you There is only one lot number table, I put a 2 in the name for some reason awhile ago

This how my relevant tables are set up http://i.imgur.com/j5Ot02L.png?1 Ignore the SetRunCond table But see how the actual running conditions table is related to the parameters table. There are two different combinations of parameters i want to auto populate new records for that field in the...

I already have it set up this way My issue is when the user goes to enter the values for those parameters for a particular lot number. He is entering the lot number and manually selecting the parameter from a combobox that is fed from the machine parameter table then entering the value for that...

Hello I have a Machine Running Conditions database that records running conditions for 2 machines. The table is set up like this LotNumber Parameter Condition 130506m11 Screwspeed 100 130506m11 StockTemp 50 130506m11 KniveSpeed 75 In reality...

I can do this This will let the report return the values stored in the table (in the Min and Max fields) if the Internal field is not checked, correct?

Hello I have a report that is looking up min and max quality specifications for a product. The table with the specifications has a Yes/No check box field for when the specs are defined as "Internal". So the table looks like Product/MinValue/MaxValue/Internal I want the report to display "TEST...

Yes I can on doing that. But why does this message occur randomly? It opens fine 98% of the time.

Hello I have a database that is being shared on a network folder. I have about 4 different people using it at the same time. Occasionally, someone gets the message "The database has been placed in a state by user "admin" on machine MDSOUTH (our server) that prevents it from being opened or...

okay wow, WHY DIDNT ANYONE TELL ME THIS BEFORE. thank you!

Hello. I am designing queries to return averages for quality test data. I have this query that functions as I want it too http://i.imgur.com/K0f7ZLD.png It returns the averages of all the values received for different tests for a lot number (the lot number criteria should be filled out as well)...

http://i.imgur.com/aZQ32mD.png What is bad about it?