Search results

Thank you for your help!

Thanks to all of you for your help! I hope you all have a good day.

Nevermind, I have it going. Thanks.

OK, I can do that. The problem is now that I don't know how to reference the records in that table from behind my main form (I want to run the query when my main form opens) since it is not bound to that table or another table I use to store a list of dates.

I need to run an append query when I open my db that will look at a date in the records and copy the records when date() >= [PeriodEndDate] and some other criteria. I have the append query working perfectly. But the records still need to have some code run on them to set up fields in the new...

Thanks for you replies and sorry about the incomplete description. I posted the wrong (least clear) version of attempt of that statement. I meant to post this: DateAdd("d",1,DateSerial(Year(Date()),[LastYearMonthToMatch]-1,[LastYearMatchDateReady])) or...

On a form I have a combo where a month is entered. It shows the month names in column one, but it is bound to column two where each month's corresponding number is, ie Jan=1, Feb=2, etc. So selecting April returns 4. Also on the form I have a text box where a number is entered and used as the...

Thanks but it's not working for me. In a query it tells me that it doesn't like the last ) and as the controlsource of a text box it gives me #Name? What do you think? Am I doing something wrong?

Thanks for your reply. I already use DateDiff to get the number of weeks between dates. I now need a more exact calculation.

Is there a way to find out the number of Wednesdays between two given dates? Thank you.

I'm trying to drop decimals and zeros when they're not needed. For instance, if I type 3 I'd like to show as 3 instead of 3.00, and if I type 3.5 I'd like it to show 3.5 instead of 3.50. I can't find how to do this but surely it can be done. Thanks.

Thanks for your help pbaldy. I wasn't using the wizard, so I didn't see it. Full answer for future searchers: Row Source Type : Value List Row Source : Day(s);d;Week(s);w;Month(s);m;Year(s);y Column Count : 2 Column Widths : 1";0" Bound Column : 2 The 0" width for the second column hides...

Thanks. Can I still put the options in a value list, because I can't figure out how to do what you're saying and use the value list?

I use a Value List for options in a combo box but I don't want exactly what is selected to be written to the record. I need each selection of the combo box to correspond to another value that should be written to the record. For example: The combo options from the value list are Day(s), Week(s)...

Thanks very much for your help.

Thanks. I do see what you mean and had thought of the fact that if I didn't open the db when a record was set to be created then it wouldn't be created until I did open the db (I had planned on running the code to generate the needed records on open of the db's main form). In my case however I...

I have a db where each record is a certain task to be done. Each record includes the date the task should be completed. Some of the tasks are one time only but some are recurring. I have been having to create a new record for every task even the recurring ones, but I have decided to try to...

After more experimentation with the query wizard I got a result that looks similar to what I need. This is the code: TRANSFORM Sum(qCheckbookRegisterReport.AmountDebit) AS SumOfAmountDebit SELECT qCheckbookRegisterReport.Payee, Sum(qCheckbookRegisterReport.AmountDebit) AS [Total Of AmountDebit]...

I followed your instructions and they worked for me. I got a form (strangest form I've ever seen, haha) and though it has the info and arrangement I'm looking for, I don't think that it is exactly what I have been trying for. From what I've read I think a crosstab query (then a report based on...

I'm not familiar at all with pivot*, would this allow me to achieve my ultimate goal which is a report showing what my original post shows? My thought on asking about how to get the query done was that I would then translate that data to a report.