Search results

Is year a text or number field?

@spikepl - Ok I'll start doing that. I know it was a lot easier for me to see the me answer, work forward or backwards through the process to replicate.

You need to upload a sample of the database and I could show you how it's done.

I would change your table to use fields like date1, date2, .... date7. Add seven more fields called date1 date, date 2 date.... date 7 date. Date1 date = 11/18/2013 from your example above. Hope that helps.

I've uploaded a sample, think it's what you are asking for. I always create a common field to easily link multiple queries together. In this case I created a field called "site" and created three queries. One with the averages by year and month by task for each employee, one for averages by...

Since you are starting out, I'd just create 5 queries, one for each child field with the DOB. It would be a lot faster than recreating the database or moving the data (which you should do once you fully understand databases). I can upload a sample of a solution if you need it.

I just posted a response and a solution for the two example. I just realized you'll need to adjust the iif statements for each new country. I guess you could create a cross reference table for all the countries, that way if a new country is added, just enter it in the new table for it to work.

Here's a solution with one query using various functions, Replace, InSt, Left Right, Mid. These are all great things to know for working with data like this. Picture of results and database uploaded.

Not sure how it happened in your case. I've had it happened over the years, just need to recognize an be able to fix. I usually send it back to my IT Dba guy and ask if their is something wrong with the view they are giving me and point out the space.

can you upload a database with a sample of the data, I can show you the solution.

Change one of your query criteria to this: >IIf(Weekday(Date())=1,Date()-3,Date()-1) I uploaded a sample.

Yes, the space is the problem. I uploaded a solution. I use the trim and mid functions. The matches are in this query: QryOffOfTrimmedTable

If Wayne Ryan's post doesn't help, I can upload a sample.

You just need a good teacher/class. Until you start to see examples and work through things on your own, these can be confusing. I always like to work backwards from a finished database. I hardly ever use VBA and SQL in Access. Here is a sample database. It should open directly to the...

Here's a sample database to get you started. Let me know if you have any questions. If the form frmLabels doesn't open automatically, start there to see how the database is working.

No hard feelings, but I disagree with the "hard (or impossible)" comment.

You should be able to follow my queries if you have them in name order. Start at the first one and understand what it's doing, then move to the next. I added one more spare machine to the data, it has 5 parts with three matching a machine that needs the parts. I changed...

David r, saves you from checking null but you'll have a customer for each order. Each customer should have an id number. Not sure how that would work.

Exactly right. Leave it blank and it becomes the generic customer price. Follow the queries in alpha name order one by one and understand how it works.

I mostly use the design view when building queries instead of SQL. I'll try to upload a sample.