Recent content by JYeoman

Thanks for that link - I used your info on joining another query onto another one using INNER JOIN. I kept the first query with only the SELECT Max(AllData.[Week Number]) AS WeekNumber FROM AllData WHERE (((AllData.Total_Sales)<>0)); and then used in a second query SELECT...

Hi, already had that part working - but now I can't add any other fields. Basically what I am trying to do here is eliminate possibility for user error. In my current query It asks the user to put in the week number, then it returns only the record (about 20 fields) with that week number. Now I...

This now lists all records in ascending order of Hamilton_Residential values, instead of only the record with highest [Week Number] value (autonumber)

I just edited my post (you were very quick to reply :D) SELECT Max(AllData.[Week Number]) AS WeekNumber, AllData.Hamilton_Residential FROM AllData WHERE (((AllData.Total_Sales)<>0));

The reason I did it the way I did, was because for some reason the calculations in queries would error for me. For example: [AllData].[Hamilton_Residential]+[AllData].[Hamilton_Commercial] AS Hamilton_Sum In my SQL returns the error "Your query does not include the specified expression...

BTW the problem was with a typo in the table field name. Following code works SELECT Max(AllData.[Week Number]) AS WeekNumber FROM AllData WHERE NOT (AllData.[Total_Sales]) = 0;

Hi, I am writing SQL for a query in which I find the highest number in an autonumber. That in itself is very easy, however the users often create new records by mistake without filling them in. This is a problem because the autonumber is referenced in another query which returns the rest of the...

I converted it to VBA and used the following code: Function SavePDF() DoCmd.OutputTo acOutputReport, "Weekly Report", _ acFormatPDF, "E:\Flooring Design\Test PDF\Weekly Report" & "_" & Format(Date, "yyyy_mm_dd") & ".pdf" End Function However, I've since realised that my report prints a few...

Hi, I have a macro to export the report I created as a PDF, and it works perfectly fine. However, I would like to take away the 1 last option for user error and have it automatically name it "Weekly Report" and the current date. I have tried the following in the 'Output File' section of the...

In my tables I have some calculated fields which look like [WeeklySales]/60000 where [WeeklySales] is input via form. This calculated form returns a percentage. There are also a couple of other areas which use this number, such as a query and a report, but 1 step at a time. The point is, these...

Actually this worked perfectly. Very simple, thanks!

ok, so I tried to add in the othr 9 fields to sum up into that expression builder, and received a 'mismatch' error, highlighting the code: result = result + CDbl(newstr) I then erased it back to the 3 textboxes to add, and now it keeps showing that error

You BEAUTIFUL person

Same answer, but I figured that it could possibly be showing the answer as 1 038.00 could be 1.038 million. I added the numbers up by myself and it was roughly 1 039 000 - could be a formatting and rounding issue now =\

This is the first attempt at making this happen that actually gave me a calculated answer! However the calculation it gave me was very very wrong :D For example, the running total after 8 records was the following, and the result below: $386 845.79 $395 254.86 $257 062.66 The calculation gave...