Search results

Oh, okay. Thanks. I figured it'd be something like that.

Is it possible, and if so, how, to change the colors of the background area where the navigation bar is? (Area marked within included image)

Okay, I fixed the query code. Im not exactly sure what I did, or if what I did out of what all i've done since the last post, have had any point of doing what so ever. But i've fixed it and the only thing i can think of that i've changed was one of the field's names was "Name". And because of...

(sorry for double post) Okay, after trying out the most recent suggestion by Jon K, I am still getting the extra 4th parameter asking for the same thing as included/attached in the previous post. :confused: Here is the SQL for the query as requested.

Not sure if it works yet, but a quick question. Is that bolded part of the quote above the asterick part of the Query Design View Field Select box where all the tables are selected? If so, this wouldnt work would it? Because in order to have the asterick in the field to select all, and have a...

A query does indeed sound like what you need. You could try using the totals in the query design view wich is the omega button, then using the fields that have the materials you need added,multiplied, or subtracted from each other do such by the drop down list that appears fromt he new row after...

I used this suggestion, and everything seemed to work out fine, but there seems to be a reading problem in acces where instead of 3 parameters popping up, there's 4. Its the second parameter that i dont want, and it pops up and keeps saying: "tblexample.fieldA" (actually its the actual table...

It's been 2 days so far. Does anyone have any idea how to do this? Or does everyone just not understand what I'm asking?

Yea, i was going to suggest just changing every null value to the number "0" but using the nz function in the query would definitely help alot. Doing that will make it easier to search for what you dont have in inventory. To do this try using an update query function to change all " " to "0"...

Try posting the SQL Code for the already created table. This will allow many of the users to explain the problem in a more detailed manner.

In other words, within the criteria field of the query under that specific Field, change the code from [Enter Week Commencing], to < [Enter Week Commencing] NOTE: This will permenantly change the query unless changed back through the criteria field.

I see where you are have mistaken this. That example is for when the records in the file are null. But what I am asking is for help of when the Parameter input is null. Like when the user does not enter anything into the parameter that pops up, for it to just ignore that particular parameter...

What I am trying to do is create 3 (or more) parameters for a query from a single table. Lets use this for example: Table Name= "tblExample" Field Name "A" with Perameter "1" Field Name "B" with Perameter "2" Field Name "C" with Perameter "3" (All from Table= "tblExample") My intentions are...

You could try creating a query in design view that includes that particular table. Then from that table only, add the cboCategory field. (If I understand you correctly), you can then use the criteria row to filter out the "categoryA" from whatever field "categoryA" is in. Also on the queries bar...