Ares6881
Last Activity: Nov 3 '09, 11:56 PM
Joined: Jul 13 '07
Location:
-
I found the error, moddisc was part of a table I removed, by re-adding the table and the field it fixed the error. Still wish the error was more descriptive, but what can you do, it's MS ;P -
I seem to have narrowed it down to two text boxes in the report, one is
=IIf(IsNull([moddisc]),"Average discount for " & [Fyear]-1,"Modified Discount")
the other is
=IIf(IsNull([moddisc]),[DiscPercent],[moddisc]*100 & "%")
the strange thing is I have these exact same boxes in another report that works fine. I have run a compact and repair, but that didn't do...Leave a comment:
-
Here's the final query after that
...Code:SELECT qryForecastByTerritoryPrices.cterr, qryForecastByTerritoryPrices.PlantID, qryForecastByTerritoryPrices.FYear, qryForecastByTerritoryPrices.YPercent, qryForecastByTerritoryPrices.DiscPercent, qryForecastByTerritoryPrices.MinOfnprice, qryForecastByTerritoryPrices.SumofForecast, qryForecastByTerritoryPrices.[01 January], qryForecastByTerritoryPrices.[02 February], qryForecastByTerritoryPrices.[03 March],
Leave a comment:
-
Here's the code to the crosstab Query
...Code:PARAMETERS [forms]![frmReports]![terryear] Short; TRANSFORM Sum(Int([forecast]*[Ypercent])*[minofnprice]) AS Plants SELECT qryLastYearPercents.Territory AS cterr, tblMonthlyForecast.PlantID, tblMonthlyForecast.FYear, qryLastYearPercents.YPercent, qryLastYearPercents.DiscPercent, qryPlantPrices.MinOfnprice, Sum([Forecast]*[minofnprice]) AS SumofForecast FROM (tblMonthlyForecast INNER
Leave a comment:
-
Access does not recognize " as a valid field name
This error has been driving me a little bit nuts, I have 2 reports going off the same query, the query pulls in data from a crosstab query. One of the reports is working just fine, but whenever I try to run the fourth one I get the error (the microsoft office access database engine does not recognize " as a valid field name or expression). The strangest part is that the query that feeds into the report runs just fine on its own. The only... -
Unfortunately, the database itself contains proprietary information, and with all the links to other tables, etc.. It would likely take quite a bit to break it out. Essentially what's going on is when the on page event runs the information is from the next page instead of the page that I'm on, and since it's in two pages the first page has the correct information, while the second one has the information for the next item on the list (in the VBA...Leave a comment:
-
I'm running Access 2007, it's showing up as an option for some reason, I can post a screen shot, but right now I'm using the on Page event anyway.Leave a comment:
-
Conditional Pictures in a report
Hi, I've run into a snag here and hopefully someone here can help. Basically what I'm trying to do is set it up so the user only needs to place a properly formatted picture in a directory to get it to show up in the report. The problem I'm running into is that each record shows up on two or more pages, when I have my code set to run on current it never runs, so I've tried to run the code on page, the problem is that as soon as I get to the next... -
That would work, though he is new to access, and it wouldn't show any other fields they may want. Just put
chkForV: iif([Field1] like "*v*", "OK", "Not OK")
as one of your columns in a new query of your table, then put whatever information you want in the other columns. Again, like mlcampeau said...Leave a comment:
-
I think this might work for you
It checks to see if the data has a v in it, if it does it says OK, if not it says Not OK....Code:iif(like "*v*", "OK", "Not OK")
Leave a comment:
-
that wont give the same thing, I'm using "ww" for weeks, not "mm" for months, however, I can substitute the week in there and that should work, thanks ;)...Leave a comment:
-
He was comparing the current month to last month I believe, anyway, sorry for my absence, work and all.
Not sure why the criteria didn't work for you, what it sounds like to me is that for some reason the data that you have in that column may somehow be incompatible, but you already said that it displays properly. Let me know what your tables look like and I'll see if I can't figure out what's going on.Leave a comment:
-
Because we go by ship weeks here and weeks vary depending on the year, I've created a report that goes off of week instead of date to help the users enter data in a format they understand instead of having to look up what the beginning and end of each week is every time.
An example is august 6th this year falls on the week from august 5th to the 11th, next year it will fall on the week of august 3rd to the 9th, the year after that...Leave a comment:
-
Is there an easier way to do week range?
Hi, I was wondering if there's an easier way to get a week range than what I'm currently using. Right now I use something along these lines, where drequest is the date
Format([drequest],"yyyy") & IIf(Format([drequest],"ww")<10,"0 " & Format([drequest],"ww"),Forma t([drequest],"ww"))
this would be an example criteria for it to find out all dates between weeks... -
Yeah, that helps, alrighty one neat trick in case you didn't already know how to do it is that you can actually import from your excel sheet directly into access. It's under file/get external data/import
You'll then select Microsoft Excel from the type at the bottom then pick your file. Your file should be in the format of having your headers across the top and all your data below it to import properly. You may want to change your date...Leave a comment:
-
Is the date column set as a date value, or is it a number value with mmddyyy (only 3 y for year? or was that a mistype?) as the format. If it's just a number value it's handled a bit differently. If you don't know how to tell go to the table and go into design view, it should tell you on the right hand side what kind of value it is. Could you give me the names of each column so I can make queries that you can just plug in? Are the readings always...Leave a comment:
-
You don't need a table for each consumer, dealing with dates can be pretty tricky especially when it comes to year changes. I take it you want to deal directly with months and not days? Days can be a bit easier when dealing with date ranges, but months is still possible. Start off making a query that gets the sum of all your bills for the current month, but in your consumer name as one of your columns, then have it sum up your meter readings in...Leave a comment:
-
If you're looking to imbed them in each other, it should look something like this:
IIf([unit_amt]=1,[split1],IIf([unit_amt]=2,[split2],IIf([unit_amt]=3,[split3])))
Basically the way an IIf statement works is
IIf([argument], [result if it's true], [result if it's false])
Hope that works for ya...Leave a comment:
-
Thank you everyone for all your responses, I was able to get it working with Mike's simplified version. I've bookmarked this site and plan to return if I run into any more snags, thanks!Leave a comment:
-
Wherecondition troubles with multiple entries
Hi everyone, I'm new to these forums, but I'm having a bit of an issue. I'm basically trying to get the coding right on the wherecondition, but can't seem to figure out the correct formatting for using multiple entries. This is being used to make a report that pulls selected addresses by name. List2 is a List box, and the For loop creates data that looks like this: "Bill" OR "Jim" OR "Sandy"
Anyway,...
No activity results to display
Leave a comment: