Search results for query: *

Not too familiar with Ranges, could you expound a little?

I need help creating a procedure that will first create, and then update on a regular basis, a table in Access via information in an Excel file. I already know how to link Access to Excel info, but this is going to be a bit more specific. Description of Excel File: I have a file with four...

jjlogan, Ahhhh.....normalization. I got so caught up in how my table would look to the users that I forgot that I don't even need that information in this new table. I'll create a view or report later that shows the name with the number. But you are absolutely correct that this would...

I have a table containing several foreign keys from other linked tables. In particular I have a list of countries and their corresponding number that has been assigned to them. I want to set a the "number" field to be a picklist in the datasheet view where the user can click the dropbox arrow...

Okay, I'm sure you're getting tired of me now! This works great now and the report is working for all dates.....HOWEVER.....I need to get the report to show zero "0" in the column if nothing was completed. Any way to do this if no information is actually being passed through for that facility...

Currently the last part of the crosstab query code looks like this: PIVOT [F - Completed Facilities Summary].FT_Name; How would I tell it to list out the actual FT_Names as column headings and keep them there even if no data is coming through for those facility types from the other queries...

Ginger, How do I force it to show those? Right now the Crosstab query is trying to pick and group all "FT_Name" Facility types as the column headings. How do I specifically tell it to use certain names and put the correct data in those columns?

PHV, You were kind of correct. Actually the number is decreasing in this case and the report is wanting to show numbers in a column for which no data exists in the crosstab query during certain time-frames. I need to get my crosstab query to show a zero "0" for these facility types instead...

Okay, I figured out why it doesn't work past that date. I was not doing what you were asking. I took out all the parameters and entered a date range of 7/19/2004 - 1/24/2005 directly in the FacNum(5) query. The report wouldn't run. When I went into the report design it was not able to find...

S - All Facilities Query": SELECT TASK_ORDER.L_Name, COUNTRY.WBS, FACILITY.C_Name, FACILITY.F_Name, Count(DELIVERABLE.[Del_#]) AS [CountOfDel_#], DELIVERABLE_TYPE.Del_Code, Sum(FACILITY_DELIVERABLE.FD_Amount) AS SumOfFD_Amount, FACILITY.FT_Name, FACILITY.Number FROM (DELIVERABLE_TYPE INNER JOIN...

S - Completed Facilities Query" is actually the query that FacNum(5) is based on. Forgot to mention that. That query just gives me a list of facilities that have been comleted out of my overall list of all facilities in varying states of completion. FacNum(5) was then created to try to filter...

If I run the queries alone using typed in dates (not referencing the form controls), they work fine. So Yes, and Yes. Here are my queries: Query 1: "FacNum5" PARAMETERS [Forms]![Filter Form - Completed Facilites]![R1] DateTime, [Forms]![Filter Form - Completed Facilites]![R2] DateTime...

Actually, I'll clarify a little. It's 7/18/2004 which is the last date that the process will allow to work. Any date after that and I get the error! It's wierd!

Actually, GingerR, for some reason this works for all dates up to 8/1/2004. All prior dates the report works just fine, but for any date after this I get an error that says "The Microsoft Jet Databae engine does not recognize " as a valid field name or expression". And then the thing blows up...

Awsome! Works fine now. Thanks for your help.

Here's an interesting one. I have a crosstab query that uses a query, that uses another query which has a date field with a criteria that states the date must be between the dates the user enters in two text boxes in a form. Problem is, the report I run is based off the original crosstab query...

Will do, sorry if I wasted your time, but thanks for your consideration!

I didn't mean to, and I won't in the future. I'm new (as of this morning) and I didn't know the proper forum to post this question. After I posted in the first forum I found this one which looked more promising for my question. Thanks for the tip though.

Nevermind, I re-read your post and figured out what you meant. I needed to add the following before the final ')' ",DELIVERABLE.HQ_App_Date)". Now it works just fine. Thanks for stearing me in the right direction!

That's what I figured, but I needed another set of eyes to look at it. A co-worker wrote the code, and I've been modifying it. Problem is, we both though that the last IIF statement would create the value (become the "else") if the first IIF statement conditions were false. Thanks for your...